Openbravo Issue Tracking System - Retail Modules
View Issue Details
0037142Retail ModulesWeb POSpublic2017-10-23 17:272017-11-17 14:37
Sandrahuguet 
Sandrahuguet 
normalminorhave not tried
closedfixed 
30Openbravo Appliance 14.04
 
RR18Q1 
marvintm
No
0037142: Unnecessary joins in payments query
when payments.java query is translated from hql to sql, unnecessary joins are made
See in openbravo.log the translated query in sql
Performance
Issue History
2017-10-23 17:27SandrahuguetNew Issue
2017-10-23 17:27SandrahuguetAssigned To => Retail
2017-10-23 17:27SandrahuguetTriggers an Emergency Pack => No
2017-10-23 17:27SandrahuguetTag Attached: Performance
2017-10-24 14:03SandrahuguetAssigned ToRetail => Sandrahuguet
2017-10-25 13:22SandrahuguetSummaryUnneded joins in payments query => Unnecessary joins in payments query
2017-10-25 13:22SandrahuguetDescription Updatedbug_revision_view_page.php?rev_id=16183#r16183
2017-10-26 11:04SandrahuguetReview Assigned To => marvintm
2017-10-26 12:30hgbotCheckin
2017-10-26 12:30hgbotNote Added: 0100080
2017-10-26 12:30hgbotStatusnew => resolved
2017-10-26 12:30hgbotResolutionopen => fixed
2017-10-26 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/162b269457148eec43da7bae3b4f96dfe9d637f9 [^]
2017-11-17 14:37marvintmStatusresolved => closed
2017-11-17 14:37marvintmFixed in Version => RR18Q1

Notes
(0100080)
hgbot   
2017-10-26 12:30   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 162b269457148eec43da7bae3b4f96dfe9d637f9
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Oct 25 13:12:03 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/162b269457148eec43da7bae3b4f96dfe9d637f9 [^]

Fixed issue 37142 avoid unnecessary joins in payments query

---
M src/org/openbravo/retail/posterminal/term/Payments.java
---