Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040369Retail ModulesWeb POSpublic2019-03-13 08:232019-04-15 16:36
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
Summary0040369: Scanning of UPC is doing an Upper Equals instead of just equals
DescriptionScanning of UPC is doing an Upper Equals instead of just equals.

Remote query should have the isId Paremeter to disabled the Upper. Since Index is not taking into account the Upper performance may be impacted.
Steps To ReproduceWith Remote Products enabled.
Scan 'abc'

Look for the query executed:
" upper(product1_.UPC)=upper($1) "
Proposed Solutionupper should not be used in remote filters (neither for product1_.UPC nor $1).
Additional Information
TagsPerformance
Relationships
related to defect 0040170pi closed jorge-garcia When barcode is scanned in POS Terminal, the code is automatically set as lowercase. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-03-13 08:23guillermogilNew Issue
2019-03-13 08:23guillermogilAssigned To => Retail
2019-03-13 08:23guillermogilOBNetwork customer => Gold
2019-03-13 08:23guillermogilResolution time => 1554242400
2019-03-13 08:23guillermogilTriggers an Emergency Pack => No
2019-03-13 08:24guillermogilRelationship addedrelated to 0040170
2019-03-13 08:24guillermogilTag Attached: Performance
2019-03-13 08:25guillermogilDescription Updatedbug_revision_view_page.php?rev_id=18442#r18442
2019-04-08 11:55jorge-garciaProposed Solution updated
2019-04-10 12:14ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2019-04-10 12:14ranjith_qualiantech_comStatusnew => scheduled
2019-04-11 09:43hgbotCheckin
2019-04-11 09:43hgbotNote Added: 0111077
2019-04-11 09:43hgbotStatusscheduled => resolved
2019-04-11 09:43hgbotResolutionopen => fixed
2019-04-11 09:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3bdd3aba4fe3c3a951038f2e2e1671386b97757c [^]
2019-04-15 16:36adrianromeroReview Assigned To => adrianromero
2019-04-15 16:36adrianromeroNote Added: 0111145
2019-04-15 16:36adrianromeroStatusresolved => closed
2019-04-15 16:36adrianromeroFixed in Version => RR19Q3

Notes
(0111077)
hgbot   
2019-04-11 09:43   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 3bdd3aba4fe3c3a951038f2e2e1671386b97757c
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu Apr 11 13:13:14 2019 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3bdd3aba4fe3c3a951038f2e2e1671386b97757c [^]

Fixed issue 40369 : Scanning UPC should validate the exact value in backoffice

* If remote filter is enabled, while scanning upc, exact value should be checked in backoffice

---
M web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js
---
(0111145)
adrianromero   
2019-04-15 16:36   
Verified