Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032605Openbravo ERPA. Platformpublic2016-04-05 17:092016-06-17 19:36
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032605: widgets summary field not displayed if HQL has group by clause
DescriptionHQL Query Widgets that have a group by clause in their HQL and a summary column, do not display the summarized value for that column.
Steps To Reproduce1. Apply attached diff that restores and defines properly summary function for Quantity on Hand column of Stock By Warehouse widget
2. Rebuild
3. Add stock by warehouse widget
  -> Note summary function is not displayed
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00291743.0PR15Q2 closed AugustoMauch Summarize fields are not displayed in widgets 
Attached Filesdiff Stock-By-Warehouse-Sum-Qty.diff (1,521) 2016-04-05 17:09
https://issues.openbravo.com/file_download.php?file_id=9239&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-04-05 17:09alostaleNew Issue
2016-04-05 17:09alostaleAssigned To => platform
2016-04-05 17:09alostaleModules => Core
2016-04-05 17:09alostaleTriggers an Emergency Pack => No
2016-04-05 17:09alostaleAssigned Toplatform => alostale
2016-04-05 17:09alostaleReview Assigned To => caristu
2016-04-05 17:09alostaleFile Added: Stock-By-Warehouse-Sum-Qty.diff
2016-04-05 17:15hgbotCheckin
2016-04-05 17:15hgbotNote Added: 0085449
2016-04-05 17:15hgbotCheckin
2016-04-05 17:15hgbotNote Added: 0085450
2016-04-05 17:15hgbotStatusnew => resolved
2016-04-05 17:15hgbotResolutionopen => fixed
2016-04-05 17:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/24f92e6306589db59f5b54041db7f34706e8c94a [^]
2016-04-05 17:15alostaleRelationship addedrelated to 0029174
2016-04-08 10:41hgbotCheckin
2016-04-08 10:41hgbotNote Added: 0085512
2016-04-08 10:53caristuNote Added: 0085513
2016-04-08 10:53caristuNote Deleted: 0085513
2016-04-08 10:54caristuNote Added: 0085514
2016-04-08 10:54caristuStatusresolved => closed
2016-04-08 10:54caristuFixed in Version => 3.0PR16Q3
2016-06-17 19:36hudsonbotCheckin
2016-06-17 19:36hudsonbotNote Added: 0087424
2016-06-17 19:36hudsonbotCheckin
2016-06-17 19:36hudsonbotNote Added: 0087425
2016-06-17 19:36hudsonbotCheckin
2016-06-17 19:36hudsonbotNote Added: 0087434

Notes
(0085449)
hgbot   
2016-04-05 17:15   
Repository: erp/devel/pi
Changeset: 5f1c8bb5f1caeb53238c8137d0983bd947d8036f
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Apr 05 17:12:02 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5f1c8bb5f1caeb53238c8137d0983bd947d8036f [^]

related to bug 32605: widget summary not displayed if HQL has group by clause

  Added log in case exception is thrown when executing summary query.

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
---
(0085450)
hgbot   
2016-04-05 17:15   
Repository: erp/devel/pi
Changeset: 24f92e6306589db59f5b54041db7f34706e8c94a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Apr 05 17:13:38 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/24f92e6306589db59f5b54041db7f34706e8c94a [^]

fixed bug 32605: widgets summary field not displayed if HQL has group by clause

  When calculating in backend summary function, group by clause must be removed
  from the query as all values should be aggregated without grouping.

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
---
(0085512)
hgbot   
2016-04-08 10:41   
Repository: erp/devel/pi
Changeset: 075d80ce3160b70c71d83e099f190f92b3f23e39
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Apr 08 10:40:36 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/075d80ce3160b70c71d83e099f190f92b3f23e39 [^]

related to bug 32605: removed some duplication

  hql where clause was converted to lower case several times

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
---
(0085514)
caristu   
2016-04-08 10:54   
Code review + testing OK: using widget with the summary function defined properly, the summary field is displayed.
(0087424)
hudsonbot   
2016-06-17 19:36   
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/0dc7be081b1c [^]
Maturity status: Test
(0087425)
hudsonbot   
2016-06-17 19:36   
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/0dc7be081b1c [^]
Maturity status: Test
(0087434)
hudsonbot   
2016-06-17 19:36   
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/0dc7be081b1c [^]
Maturity status: Test