Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040567Retail ModulesWeb POSpublic2019-04-10 11:052019-04-24 12:43
Reporterguillermogil 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q3 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040567: Not needed extra join in Product query
DescriptionNot needed extra join in Product query.
On the order by it is using pli.product instead product directly.
Steps To ReproduceN/A
Proposed SolutionSee attached patch
Additional Information
TagsPerformance
Relationships
Attached Filesdiff patch.diff (571) 2019-04-10 11:05
https://issues.openbravo.com/file_download.php?file_id=12849&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-04-10 11:05guillermogilNew Issue
2019-04-10 11:05guillermogilAssigned To => Retail
2019-04-10 11:05guillermogilFile Added: patch.diff
2019-04-10 11:05guillermogilOBNetwork customer => Gold
2019-04-10 11:05guillermogilResolution time => 1554069600
2019-04-10 11:05guillermogilTriggers an Emergency Pack => No
2019-04-10 11:06guillermogilTag Attached: Performance
2019-04-10 11:10guillermogilResolution time1554069600 => 1556661600
2019-04-11 11:53ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2019-04-12 07:24ranjith_qualiantech_comStatusnew => scheduled
2019-04-12 07:42hgbotCheckin
2019-04-12 07:42hgbotNote Added: 0111087
2019-04-12 07:42hgbotStatusscheduled => resolved
2019-04-12 07:42hgbotResolutionopen => fixed
2019-04-12 07:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d242fa20e08b2c48d09cf64a6c1f47e62b36f6b2 [^]
2019-04-24 12:43adrianromeroReview Assigned To => adrianromero
2019-04-24 12:43adrianromeroNote Added: 0111267
2019-04-24 12:43adrianromeroStatusresolved => closed
2019-04-24 12:43adrianromeroFixed in Version => RR19Q3

Notes
(0111087)
hgbot   
2019-04-12 07:42   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d242fa20e08b2c48d09cf64a6c1f47e62b36f6b2
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Fri Apr 12 11:11:47 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d242fa20e08b2c48d09cf64a6c1f47e62b36f6b2 [^]

Fixed issue 40567 : Update Product query to use direct product reference instead of join reference

---
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0111267)
adrianromero   
2019-04-24 12:43   
Verified.