Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0034324
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] B. User interfacemajoralways2016-10-27 15:312017-03-16 09:40
ReporterpradeepvarmaView Statuspublic 
Assigned Toinigosanchez 
PriorityhighResolutionfixedFixed in Version3.0PR17Q1
StatusclosedFix in branchFixed in SCM revision10d06da08054
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0PR16Q3.1SCM revision 
Review Assigned Tocaristu
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034324: Summary function does not function for WIndow's created using hql tables.

DescriptionThe summary function for numeric fields donot function correctly for windows created using tables that are defined using HQL query.
For more info , attached are the screenshots of table defn, window defn
Steps To Reproduce1. Log in to the ERP as system admin.
2. Create a table using HQL query and define its columns in AD
3. Create a window for the table and create a menu record.
4. Open the newly created window and the data is visible. But when you right click on any quantity field and navigate to "set summary function" -> select "sum", the results on the summary tab are entirely wrong.

For video of the issue :
http://www.screencast.com/t/84bTgoBg [^]
TagsNo tags attached.
Attached Filesgz file icon summary_function.tar.gz [^] (876,660 bytes) 2016-10-27 15:31
? file icon issue34324.export [^] (2,598 bytes) 2016-11-28 00:50

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0034635 newTriage Platform Base Add ability to use Summary Functions in tabs based on HQL Query. 
related to feature request 00335823.0PR17Q1 closedcaristu make summary functions deactivable 
has duplicate defect 0029858 closedinigosanchez Summary functions don't work on tabs defined based on HQL Query Tables 
related to design defect 0029765 acknowledgedTriage Platform Base Cannot add summary functions to formula fields 
related to defect 0035536 closedinigosanchez Problem to use summary function in a computed column that has a selector as reference 
related to defect 0036406 closedinigosanchez Summary functions do not work in tabs based on tables with Datasource Data Origin 

-  Notes
(0091273)
inigosanchez (developer)
2016-11-09 12:31

Problem is reproduced in core. Product Window > Select "Cerveza Ale 0,5L" product > Costing Tab > Select any record with values in subtab > Average Cost Transactions Tab> Applied Summary Function Sum for Movement Qty column. Summary function is not applied properly.
(0091871)
inigosanchez (developer)
2016-11-28 00:51

Fix issue in attached file: issue34324.export
(0091891)
hgbot (developer)
2016-11-28 13:33

Repository: erp/devel/pi
Changeset: 10d06da08054dfadc0c2c3302e8d8457e9ac6fbf
Author: Inigo Sanchez <inigo.sanchez <at> openbravo.com>
Date: Mon Nov 28 00:48:36 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/10d06da08054dfadc0c2c3302e8d8457e9ac6fbf [^]

Fixed issue 34324:Summary functions do not work in tabs based on HQL queries.

The summary functions didn't work in tabs based on HQL queries because this
functionality was not developed. The HQLDataSourceService hadn't the code to
managed summary functions properly.

To avoid this problem, it has been resolved by blocking the use of the summary
functions in the tabs based on HQL query.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewGridComponent.java
---
(0091892)
hgbot (developer)
2016-11-28 13:33

Repository: erp/devel/pi
Changeset: dfb7e6e434776a71768fd5a5ad0e7787070e5f92
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Nov 28 13:31:28 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/dfb7e6e434776a71768fd5a5ad0e7787070e5f92 [^]

related to issue 34324: Code review improvements

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewGridComponent.java
---
(0091893)
caristu (developer)
2016-11-28 13:35

Code review + testing OK: grid summaries are not allowed for HQL based tables.

- Tested on a standard HQL based tab (Average Cost Transactions)
- Tested on Order-Invoices P&E grid (by using the AD to set the summary function)
(0092668)
hudsonbot (developer)
2016-12-16 18:39

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/dc8bf00badd0 [^]
Maturity status: Test
(0092669)
hudsonbot (developer)
2016-12-16 18:39

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/dc8bf00badd0 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-10-27 15:31 pradeepvarma New Issue
2016-10-27 15:31 pradeepvarma Assigned To => platform
2016-10-27 15:31 pradeepvarma File Added: summary_function.tar.gz
2016-10-27 15:31 pradeepvarma Web browser => Google Chrome
2016-10-27 15:31 pradeepvarma Modules => Core
2016-10-27 15:31 pradeepvarma Triggers an Emergency Pack => No
2016-11-07 13:33 pradeepvarma Web browser Google Chrome => Google Chrome
2016-11-07 13:33 pradeepvarma Resolution time => 1480287600
2016-11-08 11:12 inigosanchez Assigned To platform => inigosanchez
2016-11-09 12:31 inigosanchez Note Added: 0091273
2016-11-24 16:13 inigosanchez Status new => scheduled
2016-11-25 12:56 inigosanchez Relationship added related to 0034635
2016-11-28 00:49 inigosanchez Review Assigned To => caristu
2016-11-28 00:49 inigosanchez Web browser Google Chrome => Google Chrome
2016-11-28 00:50 inigosanchez File Added: issue34324.export
2016-11-28 00:51 inigosanchez Note Added: 0091871
2016-11-28 13:33 hgbot Checkin
2016-11-28 13:33 hgbot Note Added: 0091891
2016-11-28 13:33 hgbot Status scheduled => resolved
2016-11-28 13:33 hgbot Resolution open => fixed
2016-11-28 13:33 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/10d06da08054dfadc0c2c3302e8d8457e9ac6fbf [^]
2016-11-28 13:33 hgbot Checkin
2016-11-28 13:33 hgbot Note Added: 0091892
2016-11-28 13:35 caristu Note Added: 0091893
2016-11-28 13:35 caristu Status resolved => closed
2016-11-28 13:35 caristu Fixed in Version => 3.0PR17Q1
2016-12-01 13:21 alostale Relationship added related to 0029765
2016-12-16 18:39 hudsonbot Checkin
2016-12-16 18:39 hudsonbot Note Added: 0092668
2016-12-16 18:39 hudsonbot Checkin
2016-12-16 18:39 hudsonbot Note Added: 0092669
2017-01-02 23:37 eugeni Issue Monitored: eugeni
2017-03-16 09:40 caristu Relationship added related to 0033582
2017-03-16 09:41 alostale Relationship added related to 0035536
2017-07-04 11:24 ngarcia Relationship added has duplicate 0029858
2017-07-17 08:57 caristu Relationship added related to 0036406


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker