0039215: Modify the product search on Web Pos.

Description

It is required that the SQL returns only the products that start with the text/number entered in the search.

Steps To Reproduce

Example:

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 Solution

Modify 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';
    }

Issue History
Date Modified	Username	Field	Change
2018-09-03 13:02	Leyre	New Issue
2018-09-03 13:02	Leyre	Assigned To	=> Retail
2018-09-03 13:02	Leyre	Triggers an Emergency Pack	=> No

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.