Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037111Retail ModulesWeb POSpublic2017-10-19 09:422017-10-23 17:20
Reportermalsasua 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q1 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customerOBPS
Support ticket48147
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037111: "Order by Name" should be removed from masterdata Business Partner query
DescriptionThe masterdata business partner query is sorting by "name", and it is not necesary and it is afecting to performance
Steps To Reproduceexecute the query with and without "order by name" clause
Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-10-19 09:42malsasuaNew Issue
2017-10-19 09:42malsasuaAssigned To => Retail
2017-10-19 09:42malsasuaOBNetwork customer => Yes
2017-10-19 09:42malsasuaSupport ticket => 48147
2017-10-19 09:42malsasuaResolution time => 1510268400
2017-10-19 09:42malsasuaTriggers an Emergency Pack => No
2017-10-19 09:43malsasuaTag Attached: Performance
2017-10-19 09:44malsasuaIssue Monitored: egoitz
2017-10-19 09:55eugeniIssue Monitored: eugeni
2017-10-19 10:55marvintmAssigned ToRetail => marvintm
2017-10-19 10:55marvintmStatusnew => scheduled
2017-10-20 10:21hgbotCheckin
2017-10-20 10:21hgbotNote Added: 0099974
2017-10-20 10:21hgbotStatusscheduled => resolved
2017-10-20 10:21hgbotResolutionopen => fixed
2017-10-20 10:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/488feff5e3c2669b9cd6a3ddcd43643d85ce6ab6 [^]
2017-10-23 15:37migueldejuanaNote Added: 0100000
2017-10-23 17:20migueldejuanaReview Assigned To => migueldejuana
2017-10-23 17:20migueldejuanaNote Added: 0100004
2017-10-23 17:20migueldejuanaStatusresolved => closed
2017-10-23 17:20migueldejuanaFixed in Version => RR18Q1
2017-10-23 17:21migueldejuanaNote Deleted: 0100000

Notes
(0099974)
hgbot   
2017-10-20 10:21   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 488feff5e3c2669b9cd6a3ddcd43643d85ce6ab6
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Oct 19 10:43:53 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/488feff5e3c2669b9cd6a3ddcd43643d85ce6ab6 [^]

Fixed issue 37111. BusinessPartner query will be ordered by name only in remote mode.

---
M src/org/openbravo/retail/posterminal/master/BusinessPartner.java
---
(0100004)
migueldejuana   
2017-10-23 17:20   
Tested and reviewed