Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035812Retail ModulesWeb POSpublic2017-04-20 16:502017-05-02 15:39
ReporterSandrahuguet 
Assigned ToSandrahuguet 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035812: Upc filter is wrong built in remote query for products
DescriptionUpc filter is wrong built in remote query for products. The "upper" function is concatenated twice:

upper(upper(product1_.UPC)) like upper($2)
Steps To ReproduceSee product query in the log
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0029160RR15Q2 closed aaroncalero The BarcodeActionHandler component should be refactored to allow more specific extensions 
related to defect 0035893 new Retail MultiUpc filter is wrong built in remote query for products 
Attached Filesdiff 35812.diff (6,357) 2017-04-21 11:44
https://issues.openbravo.com/file_download.php?file_id=10686&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-04-20 16:50SandrahuguetNew Issue
2017-04-20 16:50SandrahuguetAssigned To => Retail
2017-04-20 16:50SandrahuguetTriggers an Emergency Pack => No
2017-04-20 16:50SandrahuguetTag Attached: Performance
2017-04-20 16:51SandrahuguetRelationship addedrelated to 0029160
2017-04-21 11:44SandrahuguetFile Added: 35812.diff
2017-04-21 11:45SandrahuguetResolution time => 1494540000
2017-04-21 11:45SandrahuguetSeverityminor => major
2017-04-24 09:14hgbotCheckin
2017-04-24 09:14hgbotNote Added: 0096109
2017-04-24 09:14hgbotStatusnew => resolved
2017-04-24 09:14hgbotResolutionopen => fixed
2017-04-24 09:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/6aea41f9c9fa4ac2079fb3a08df144fb041ddf04 [^]
2017-04-24 09:15SandrahuguetReview Assigned To => marvintm
2017-04-24 09:15SandrahuguetAssigned ToRetail => Sandrahuguet
2017-05-02 15:39migueldejuanaReview Assigned Tomarvintm => migueldejuana
2017-05-02 15:39migueldejuanaNote Added: 0096316
2017-05-02 15:39migueldejuanaStatusresolved => closed
2017-05-02 15:44migueldejuanaRelationship addedrelated to 0035893

Notes
(0096109)
hgbot   
2017-04-24 09:14   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 6aea41f9c9fa4ac2079fb3a08df144fb041ddf04
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Apr 21 08:35:34 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/6aea41f9c9fa4ac2079fb3a08df144fb041ddf04 [^]

Fixed issue 35812 removed upper function in upc column in remote mode

---
M src/org/openbravo/retail/posterminal/master/ProductProperties.java
---
(0096316)
migueldejuana   
2017-05-02 15:39   
Tested and reviewed