Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035893Retail ModulesMulti UPC/EAN for Productpublic2017-05-02 15:432017-05-02 15:52
Reportermigueldejuana 
Assigned ToRetail 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035893: MultiUpc filter is wrong built in remote query for products
DescriptionMultiUpc filter is wrong built in remote query for products. The "upper" function is concatenated twice:

upper(upper(multiupc.upc)) like upper($2)

https://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/file/1b148a048132/src/org/openbravo/retail/multiupc/MultiUPCProperties.java#l28 [^]
Steps To ReproduceSee description
Proposed SolutionSame resolution like in 35812
Additional Information
TagsPerformance
Relationships
related to defect 0035812 closed Sandrahuguet Upc filter is wrong built in remote query for products 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-05-02 15:43migueldejuanaNew Issue
2017-05-02 15:43migueldejuanaAssigned To => Retail
2017-05-02 15:43migueldejuanaTriggers an Emergency Pack => No
2017-05-02 15:44migueldejuanaRelationship addedrelated to 0035812
2017-05-02 15:52SandrahuguetTag Attached: Performance

There are no notes attached to this issue.