Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033582Openbravo ERPA. Platformpublic2016-08-01 15:482016-12-16 18:37
Reporteralostale 
Assigned Tocaristu 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q1Fixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033582: make summary functions deactivable
DescriptionSummary functions can cause performance problems in environments with big volumes of data.

It should be possible to disable this functionality by adding a new setting in grid configuration.

Project page: http://wiki.openbravo.com/wiki/Projects:Deactivable_Summary_Functions [^]
Steps To Reproduce-
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0033588 closed caristu Datasource Request done having a summary function with lazy filtering enabled 
related to design defect 0033591 new Triage Platform Base Datasource request fired after displaying a new column in grid having lazy filtering enabled 
related to defect 0034324 closed inigosanchez Summary function does not function for WIndow's created using hql tables. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-08-01 15:48alostaleNew Issue
2016-08-01 15:48alostaleAssigned To => platform
2016-08-01 15:48alostaleModules => Core
2016-08-01 15:48alostaleTriggers an Emergency Pack => No
2016-08-02 09:25caristuRelationship addedrelated to 0033588
2016-08-02 09:29alostaleTag Attached: Performance
2016-08-02 09:29alostaleStatusnew => acknowledged
2016-08-02 09:51caristuRelationship addedrelated to 0033591
2016-08-08 13:27caristuAssigned Toplatform => caristu
2016-08-08 13:27caristuStatusacknowledged => scheduled
2016-08-09 14:08hgbotCheckin
2016-08-09 14:08hgbotNote Added: 0088924
2016-08-09 14:08hgbotStatusscheduled => resolved
2016-08-09 14:08hgbotResolutionopen => fixed
2016-08-09 14:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c070107d842a7b2ba4a466e69784f7e64ac4fc04 [^]
2016-08-09 14:09caristuReview Assigned To => alostale
2016-08-09 14:09caristuIssue Monitored: alostale
2016-08-10 14:46caristuNote Added: 0088958
2016-08-11 12:02hgbotCheckin
2016-08-11 12:02hgbotNote Added: 0088972
2016-08-11 12:03caristuNote View State: private: 88958
2016-08-11 12:03caristuStatusresolved => new
2016-08-11 12:03caristuResolutionfixed => open
2016-08-11 12:03caristuStatusnew => scheduled
2016-08-11 18:40hudsonbotCheckin
2016-08-11 18:40hudsonbotNote Added: 0089054
2016-08-11 18:40hudsonbotCheckin
2016-08-11 18:40hudsonbotNote Added: 0089057
2016-08-29 11:39caristuTarget Version => 3.0PR17Q1
2016-08-29 11:40caristuFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/c070107d842a7b2ba4a466e69784f7e64ac4fc04 [^] =>
2016-08-30 09:09caristuDescription Updatedbug_revision_view_page.php?rev_id=12963#r12963
2016-10-17 09:24hgbotCheckin
2016-10-17 09:24hgbotNote Added: 0090609
2016-10-17 09:24hgbotStatusscheduled => resolved
2016-10-17 09:24hgbotResolutionopen => fixed
2016-10-17 09:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bbfa7b5fc9dc239210b919110881d16a50536153 [^]
2016-10-17 09:25caristuNote Deleted: 0088958
2016-10-17 09:26caristuNote Added: 0090610
2016-10-24 15:24alostaleNote Added: 0090821
2016-10-24 15:24alostaleStatusresolved => closed
2016-10-24 15:24alostaleFixed in Version => 3.0PR17Q1
2016-12-16 18:37hudsonbotCheckin
2016-12-16 18:37hudsonbotNote Added: 0092513
2017-03-16 09:40caristuRelationship addedrelated to 0034324

Notes
(0088924)
hgbot   
2016-08-09 14:08   
Repository: erp/devel/pi
Changeset: c070107d842a7b2ba4a466e69784f7e64ac4fc04
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Tue Aug 09 14:06:03 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c070107d842a7b2ba4a466e69784f7e64ac4fc04 [^]

fixes issue 33582: make summary functions deactivable

Make it possible to deactivate the summary functions in standard window grids and pick and execute grids, using Application Dictionary Grid Configuration feature.

---
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_GC_SYSTEM.xml
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_GC_TAB.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_ELEMENT.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-pick-and-execute-grid.js.ftl
M modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-view-grid.js.ftl
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewGridComponent.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewUtil.java
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-grid.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-view.js
---
(0088972)
hgbot   
2016-08-11 12:02   
Repository: erp/devel/pi
Changeset: ebdb891c7b5ee61bebb528b5f4f878d52e27f18d
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu Aug 11 12:01:26 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ebdb891c7b5ee61bebb528b5f4f878d52e27f18d [^]

related to issue 33582: revert changes

---
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_GC_SYSTEM.xml
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_GC_TAB.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_ELEMENT.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-pick-and-execute-grid.js.ftl
M modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-view-grid.js.ftl
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewGridComponent.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewUtil.java
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-grid.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-view.js
---
(0089054)
hudsonbot   
2016-08-11 18:40   
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/edaa05b1fb18 [^]
Maturity status: Test
(0089057)
hudsonbot   
2016-08-11 18:40   
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/edaa05b1fb18 [^]
Maturity status: Test
(0090609)
hgbot   
2016-10-17 09:24   
Repository: erp/devel/pi
Changeset: bbfa7b5fc9dc239210b919110881d16a50536153
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Oct 17 09:20:44 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/bbfa7b5fc9dc239210b919110881d16a50536153 [^]

fixes issue 33582: make summary functions deactivable

---
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_GC_SYSTEM.xml
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_GC_TAB.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_ELEMENT.xml
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-pick-and-execute-grid.js.ftl
M modules/org.openbravo.client.application/src/org/openbravo/client/application/templates/ob-view-grid.js.ftl
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewGridComponent.java
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/grid/ob-view-grid.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-grid.js
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-pick-and-execute-view.js
---
(0090610)
caristu   
2016-10-17 09:26   
Test Cases added to TestLink:

https://testlink.openbravo.com/testlink/linkto.php?tprojectPrefix=Communit&item=testcase&id=Communit-10138 [^] [^]

https://testlink.openbravo.com/testlink/linkto.php?tprojectPrefix=Communit&item=testcase&id=Communit-10139 [^] [^]
(0090821)
alostale   
2016-10-24 15:24   
code reviewed + tested
(0092513)
hudsonbot   
2016-12-16 18:37   
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