Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037869Retail ModulesWeb POSpublic2018-02-09 12:572018-03-12 13:44
ReporterSandrahuguet 
Assigned ToSandrahuguet 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in VersionRR18Q2 
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
Summary0037869: Performance improvements in BPLocation query
DescriptionPerformance improvements in BPLocation query
 * order by should be modified to: c_bpartner_location_id
 * fixes properties that created unnecessaries subqueies
Steps To Reproducesee translated SQL query
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0037585 closed Sandrahuguet Performance problem in BPLocation query during the incremental refresh 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-02-09 12:57SandrahuguetNew Issue
2018-02-09 12:57SandrahuguetAssigned To => Retail
2018-02-09 12:57SandrahuguetResolution time => 1519945200
2018-02-09 12:57SandrahuguetTriggers an Emergency Pack => No
2018-02-09 13:00SandrahuguetAssigned ToRetail => Sandrahuguet
2018-02-09 14:28SandrahuguetFile Added: 37869.diff
2018-02-09 14:28SandrahuguetTag Attached: Performance
2018-02-19 12:19maiteAssigned ToSandrahuguet => Retail
2018-02-21 20:35SandrahuguetNote Added: 0102570
2018-03-02 10:50hgbotCheckin
2018-03-02 10:50hgbotNote Added: 0102910
2018-03-02 10:50hgbotStatusnew => resolved
2018-03-02 10:50hgbotResolutionopen => fixed
2018-03-02 10:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c9feefce2689d16baa503cd49a601987048a450f [^]
2018-03-02 10:51SandrahuguetReview Assigned To => marvintm
2018-03-02 10:52SandrahuguetAssigned ToRetail => Sandrahuguet
2018-03-02 13:48SandrahuguetFile Deleted: 37869.diff
2018-03-02 13:49SandrahuguetNote Deleted: 0102570
2018-03-06 19:00marvintmStatusresolved => closed
2018-03-06 19:00marvintmFixed in Version => RR18Q2
2018-03-12 13:44SandrahuguetRelationship addedrelated to 0037585

Notes
(0102910)
hgbot   
2018-03-02 10:50   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: c9feefce2689d16baa503cd49a601987048a450f
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Mar 01 12:07:52 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c9feefce2689d16baa503cd49a601987048a450f [^]

Fixed issue 37869 Performance improvements in BPLocation query

---
M src/org/openbravo/retail/posterminal/master/BPLocation.java
M src/org/openbravo/retail/posterminal/master/BPLocationProperties.java
M src/org/openbravo/retail/posterminal/master/LoadedCustomer.java
---