Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035375Retail ModulesWeb POSpublic2017-02-28 10:452017-03-10 13:00
Reporterguillermogil 
Assigned Toguilleaer 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR17Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035375: Order by name is generating bad performance under some circustances
DescriptionOn Product.java for Generic products query there is an Order by name that is generating bad performance under some circumstances.
It should be removed as it is not useful for local database and not used in remote.
Steps To ReproduceN/A
Proposed SolutionRemove Order by name
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-02-28 10:45guillermogilNew Issue
2017-02-28 10:45guillermogilAssigned To => Retail
2017-02-28 10:45guillermogilTriggers an Emergency Pack => No
2017-03-09 11:38guilleaerStatusnew => scheduled
2017-03-09 11:38guilleaerAssigned ToRetail => guilleaer
2017-03-10 09:36hgbotCheckin
2017-03-10 09:36hgbotNote Added: 0094897
2017-03-10 09:36hgbotStatusscheduled => resolved
2017-03-10 09:36hgbotResolutionopen => fixed
2017-03-10 09:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/7f86ae912c35e746d105bc204a76f76349e0b4a6 [^]
2017-03-10 11:45hgbotCheckin
2017-03-10 11:45hgbotNote Added: 0094906
2017-03-10 13:00marvintmReview Assigned To => marvintm
2017-03-10 13:00marvintmStatusresolved => closed
2017-03-10 13:00marvintmFixed in Version => RR17Q2

Notes
(0094897)
hgbot   
2017-03-10 09:36   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 7f86ae912c35e746d105bc204a76f76349e0b4a6
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Mar 09 12:47:28 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/7f86ae912c35e746d105bc204a76f76349e0b4a6 [^]

fixed Issue 35375: Remove order by from generic products query. It is not needed

- It can be removed because this query is not being used when remote products is enabled
- Using standard mode (loading masterdata to local DB) is not needed, because when products are shown in the browse tab a query is done against local DB using an order by

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0094906)
hgbot   
2017-03-10 11:45   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 843d9442e2e29eae260bde1f3aac42a2b93b967a
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Fri Mar 10 11:40:14 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/843d9442e2e29eae260bde1f3aac42a2b93b967a [^]

Related to issue 35375: Order by Product ID cannot be removed because it is needed by pagination

---
M src/org/openbravo/retail/posterminal/master/Product.java
---