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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0032605
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2016-04-05 17:092016-06-17 19:36
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR16Q3
StatusclosedFix in branchFixed in SCM revision24f92e630658
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032605: 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
TagsNo tags attached.
Attached Filesdiff file icon Stock-By-Warehouse-Sum-Qty.diff [^] (1,521 bytes) 2016-04-05 17:09 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00291743.0PR15Q2 closedAugustoMauch Summarize fields are not displayed in widgets 

-  Notes
(0085449)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
2016-04-08 10:54

 Code review + testing OK: using widget with the summary function defined properly, the summary field is displayed.
(0087424)
hudsonbot (developer)
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 (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2016-04-05 17:09 alostale New Issue
2016-04-05 17:09 alostale Assigned To => platform
2016-04-05 17:09 alostale Modules => Core
2016-04-05 17:09 alostale Triggers an Emergency Pack => No
2016-04-05 17:09 alostale Assigned To platform => alostale
2016-04-05 17:09 alostale Review Assigned To => caristu
2016-04-05 17:09 alostale File Added: Stock-By-Warehouse-Sum-Qty.diff
2016-04-05 17:15 hgbot Checkin
2016-04-05 17:15 hgbot Note Added: 0085449
2016-04-05 17:15 hgbot Checkin
2016-04-05 17:15 hgbot Note Added: 0085450
2016-04-05 17:15 hgbot Status new => resolved
2016-04-05 17:15 hgbot Resolution open => fixed
2016-04-05 17:15 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/24f92e6306589db59f5b54041db7f34706e8c94a [^]
2016-04-05 17:15 alostale Relationship added related to 0029174
2016-04-08 10:41 hgbot Checkin
2016-04-08 10:41 hgbot Note Added: 0085512
2016-04-08 10:53 caristu Note Added: 0085513
2016-04-08 10:53 caristu Note Deleted: 0085513
2016-04-08 10:54 caristu Note Added: 0085514
2016-04-08 10:54 caristu Status resolved => closed
2016-04-08 10:54 caristu Fixed in Version => 3.0PR16Q3
2016-06-17 19:36 hudsonbot Checkin
2016-06-17 19:36 hudsonbot Note Added: 0087424
2016-06-17 19:36 hudsonbot Checkin
2016-06-17 19:36 hudsonbot Note Added: 0087425
2016-06-17 19:36 hudsonbot Checkin
2016-06-17 19:36 hudsonbot Note Added: 0087434

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker