Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039215Retail ModulesWeb POSpublic2018-09-03 13:022018-09-03 13:02
ReporterLeyre 
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
Summary0039215: Modify the product search on Web Pos.
DescriptionIt is required that the SQL returns only the products that start with the text/number entered in the search.
Steps To ReproduceExample:

Product 1
name = product1

Product 2
name = product2

Product 3
name=3product

Expected result: when you search by "product" only see product1 and product2.

** There is a preference for searching in remote mode that is used for this: Use contains in Remote Product search
Proposed SolutionModify the code in ob-retail-searchproducts.js

Now:

if (inEvent.productName) {
      inEvent.productName = '%' + inEvent.productName + '%';
      whereClause += '_filter like ?';
      params.push(inEvent.productName);
    } else {
      whereClause += '1 = 1';
    }

Proposed change:
if (inEvent.productName) {
      inEvent.productName =inEvent.productName + '%';
      whereClause += '_filter like ?';
      params.push(inEvent.productName);
    } else {
      whereClause += '1 = 1';
    }
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-09-03 13:02LeyreNew Issue
2018-09-03 13:02LeyreAssigned To => Retail
2018-09-03 13:02LeyreTriggers an Emergency Pack => No

There are no notes attached to this issue.