Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034014Openbravo ERP04. Warehouse managementpublic2016-09-19 11:082016-12-16 18:37
ReporterJONHM 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034014: Slow behavior of widget "Stock by Warehouse"
DescriptionHaving a large amount of data, "stock by warehouse" widget behaves slowly
Steps To Reproduce*** ASK ENVIRONMENT DETAILS FOR JONHM ***
- Add "stock by warehouse" widget
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to feature request 0023682 closed Sandrahuguet Add to "widgets collection" module the new widget "stock warehouse" 
related to defect 0032604 closed alostale Stock by Warehouse widget logs error message 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-09-19 11:08JONHMNew Issue
2016-09-19 11:08JONHMAssigned To => platform
2016-09-19 11:08JONHMModules => Core
2016-09-19 11:08JONHMResolution time => 1476136800
2016-09-19 11:08JONHMTriggers an Emergency Pack => No
2016-09-19 16:34caristuAssigned Toplatform => Triage Finance
2016-09-19 16:34caristuCategoryI. Performance => Z. Others
2016-09-19 16:34caristuTag Attached: Performance
2016-09-19 16:37caristuRelationship addedrelated to 0023682
2016-09-19 16:37caristuCategoryZ. Others => 04. Warehouse management
2016-09-19 17:18ahernandezgilIssue Monitored: ahernandezgil
2016-09-22 17:01aferrazRelationship addedrelated to 0032604
2016-09-23 11:55aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-09-28 17:58AtulOpenbravoStatusnew => scheduled
2016-10-17 12:02hgbotCheckin
2016-10-17 12:02hgbotNote Added: 0090619
2016-10-17 12:02hgbotStatusscheduled => resolved
2016-10-17 12:02hgbotResolutionopen => fixed
2016-10-17 12:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1655f1ccceb181df59113d26580c05477f0a772c [^]
2016-10-17 12:02hgbotCheckin
2016-10-17 12:02hgbotNote Added: 0090620
2016-10-17 12:03aferrazNote Added: 0090621
2016-10-17 12:05aferrazReview Assigned To => aferraz
2016-10-17 12:05aferrazNote Added: 0090622
2016-10-17 12:05aferrazStatusresolved => closed
2016-10-17 12:05aferrazFixed in Version => 3.0PR17Q1
2016-12-16 18:37hudsonbotCheckin
2016-12-16 18:37hudsonbotNote Added: 0092514
2016-12-16 18:37hudsonbotCheckin
2016-12-16 18:37hudsonbotNote Added: 0092515

Notes
(0090619)
hgbot   
2016-10-17 12:02   
Repository: erp/devel/pi
Changeset: 1655f1ccceb181df59113d26580c05477f0a772c
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Oct 05 17:15:27 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/1655f1ccceb181df59113d26580c05477f0a772c [^]

Fixes issue 34014: Simple Stock By Warehouse Widget

Added new widget with name Simple Stock By Warehouse
New view with subquery to get qtyonhand from storage detail and joins with Product, Category, Uom, Warehouse

---
M modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_ELEMENT.xml
M modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
M modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
M modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
M modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
A modules/org.openbravo.client.widgets/src-db/database/model/views/OBWCL_STOCK_BY_WAREHOUSE_V.xml
A modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_COLUMN.xml
A modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
A modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_PACKAGE.xml
A modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_TABLE.xml
---
(0090620)
hgbot   
2016-10-17 12:02   
Repository: erp/devel/pi
Changeset: ab62853b9b6c3355bbc30ae03e8be24aeb51cb09
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Oct 10 17:12:47 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ab62853b9b6c3355bbc30ae03e8be24aeb51cb09 [^]

Related to issue 34014: Code review improvements

Change retrieved columns order in OBWCL_STOCK_BY_WAREHOUSE_V view.
Change Obwcl_Stock_By_Warehouse_V_ID column length.
Change Widgets Collection module package name.
Change OBWCL_StockByWarehouseView table java class name.

---
M modules/org.openbravo.client.widgets/src-db/database/model/views/OBWCL_STOCK_BY_WAREHOUSE_V.xml
M modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_PACKAGE.xml
M modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_TABLE.xml
---
(0090621)
aferraz   
2016-10-17 12:03   
New "Simple Stock By Warehouse" widget has been created with better performance.
(0090622)
aferraz   
2016-10-17 12:05   
Code review + Testing OK
(0092514)
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
(0092515)
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