Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034324Openbravo ERPB. User interfacepublic2016-10-27 15:312017-03-16 09:40
Reporterpradeepvarma 
Assigned Toinigosanchez 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0PR16Q3.1 
Target VersionFixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034324: 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 [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0034635 new Triage Platform Base Add ability to use Summary Functions in tabs based on HQL Query. 
related to feature request 00335823.0PR17Q1 closed caristu make summary functions deactivable 
has duplicate defect 0029858 closed inigosanchez Summary functions don't work on tabs defined based on HQL Query Tables 
related to design defect 0029765 acknowledged Triage Platform Base Cannot add summary functions to formula fields 
related to defect 0035536 closed inigosanchez Problem to use summary function in a computed column that has a selector as reference 
related to defect 0036406 closed inigosanchez Summary functions do not work in tabs based on tables with Datasource Data Origin 
Attached Filesgz summary_function.tar.gz (876,660) 2016-10-27 15:31
https://issues.openbravo.com/file_download.php?file_id=9974&type=bug
? issue34324.export (2,598) 2016-11-28 00:50
https://issues.openbravo.com/file_download.php?file_id=10117&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-10-27 15:31pradeepvarmaNew Issue
2016-10-27 15:31pradeepvarmaAssigned To => platform
2016-10-27 15:31pradeepvarmaFile Added: summary_function.tar.gz
2016-10-27 15:31pradeepvarmaWeb browser => Google Chrome
2016-10-27 15:31pradeepvarmaModules => Core
2016-10-27 15:31pradeepvarmaTriggers an Emergency Pack => No
2016-11-07 13:33pradeepvarmaWeb browserGoogle Chrome => Google Chrome
2016-11-07 13:33pradeepvarmaResolution time => 1480287600
2016-11-08 11:12inigosanchezAssigned Toplatform => inigosanchez
2016-11-09 12:31inigosanchezNote Added: 0091273
2016-11-24 16:13inigosanchezStatusnew => scheduled
2016-11-25 12:56inigosanchezRelationship addedrelated to 0034635
2016-11-28 00:49inigosanchezReview Assigned To => caristu
2016-11-28 00:49inigosanchezWeb browserGoogle Chrome => Google Chrome
2016-11-28 00:50inigosanchezFile Added: issue34324.export
2016-11-28 00:51inigosanchezNote Added: 0091871
2016-11-28 13:33hgbotCheckin
2016-11-28 13:33hgbotNote Added: 0091891
2016-11-28 13:33hgbotStatusscheduled => resolved
2016-11-28 13:33hgbotResolutionopen => fixed
2016-11-28 13:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/10d06da08054dfadc0c2c3302e8d8457e9ac6fbf [^]
2016-11-28 13:33hgbotCheckin
2016-11-28 13:33hgbotNote Added: 0091892
2016-11-28 13:35caristuNote Added: 0091893
2016-11-28 13:35caristuStatusresolved => closed
2016-11-28 13:35caristuFixed in Version => 3.0PR17Q1
2016-12-01 13:21alostaleRelationship addedrelated to 0029765
2016-12-16 18:39hudsonbotCheckin
2016-12-16 18:39hudsonbotNote Added: 0092668
2016-12-16 18:39hudsonbotCheckin
2016-12-16 18:39hudsonbotNote Added: 0092669
2017-01-02 23:37eugeniIssue Monitored: eugeni
2017-03-16 09:40caristuRelationship addedrelated to 0033582
2017-03-16 09:41alostaleRelationship addedrelated to 0035536
2017-07-04 11:24ngarciaRelationship addedhas duplicate 0029858
2017-07-17 08:57caristuRelationship addedrelated to 0036406

Notes
(0091273)
inigosanchez   
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   
2016-11-28 00:51   
Fix issue in attached file: issue34324.export
(0091891)
hgbot   
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   
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   
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   
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   
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