Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045268Retail ModulesWeb POSpublic2020-10-21 16:552020-12-02 09:53
Reportermarvintm 
Assigned Toprakashmurugesan88 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR21Q1 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression levelProduction - QA Approved
Regression date
Regression introduced in releaseRR20Q3
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045268: On Product SEARCH, operator '%' has stopped working
DescriptionBefore the changes related to Masterdata IndexedDB, it was possible to do the following search:
Adhesive%warmer

And the component would return the product "Adhesive body warmer". So you could use the character "%" as wildcard. Now it doesn't work.
Steps To Reproduce- In 20Q1, in SEARCH try to search "Adhesive%warmer" and notice that the product "Adhesive body warmer" is found
- In 20Q3, nothing is found.
Proposed SolutionWhen building the criteria for the product name search, we should split the text provided by the user by "%", and add separate criterias for each part combined with "AND" operators.

We should also consider if it makes sense to do the same change in the customer selector, as most probably the operator also worked like that in previous versions of the WebPOS
Additional Information
TagsNo tags attached.
Relationships
related to defect 0045760 closed ranjith_qualiantech_com [21Q1] With MultiUPC, on product SEARCH, operator '%' does not work properly 
related to defect 0047441 closed Retail Error when searching for products with the latest version of Chrome 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-10-21 16:55marvintmNew Issue
2020-10-21 16:55marvintmAssigned To => Retail
2020-10-21 16:55marvintmResolution time => 1605394800
2020-10-21 16:55marvintmRegression level => Production - QA Approved
2020-10-21 16:55marvintmRegression introduced in release => RR20Q3
2020-10-21 16:55marvintmTriggers an Emergency Pack => No
2020-10-21 16:55marvintmStatusnew => scheduled
2020-10-21 17:00marvintmProposed Solution updated
2020-10-21 17:11azabaletaIssue Monitored: azabaleta
2020-11-23 11:14gorka_gilAssigned ToRetail => gorka_gil
2020-11-25 15:58gorka_gilAssigned Togorka_gil => Retail
2020-11-26 12:04prakashmurugesan88Assigned ToRetail => prakashmurugesan88
2020-11-30 06:55hgbotNote Added: 0124662
2020-11-30 06:55hgbotNote Added: 0124663
2020-11-30 06:55hgbotNote Added: 0124664
2020-12-02 09:53hgbotResolutionopen => fixed
2020-12-02 09:53hgbotStatusscheduled => closed
2020-12-02 09:53hgbotFixed in Version => RR21Q1
2020-12-02 09:53hgbotNote Added: 0124683
2020-12-02 09:53hgbotNote Added: 0124684
2020-12-02 09:53hgbotNote Added: 0124685
2020-12-02 09:53hgbotNote Added: 0124686
2021-01-20 10:26lorenzofidalgoRelationship addedrelated to 0045760
2021-08-05 18:18adrianromeroRelationship addedrelated to 0047441

Notes
(0124662)
hgbot   
2020-11-30 06:55   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/200 [^]
(0124663)
hgbot   
2020-11-30 06:55   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/108 [^]
(0124664)
hgbot   
2020-11-30 06:55   
Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/60 [^]
(0124683)
hgbot   
2020-12-02 09:53   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core [^]
Changeset: 6ba4999ce6e9318c2e81d2e4822d0cd056bc892c
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-11-30T21:35:31+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/6ba4999ce6e9318c2e81d2e4822d0cd056bc892c [^]

Fixed BUG-45268: Fixes Product search using '%' operator
* Issue caused by IndexedDB changes
* Added new function to filter text by splitting '%' operator
* And adding separate criteria for each text

---
M web/org.openbravo.mobile.core/app/model/persistence/indexeddb/Criteria.js
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0124684)
hgbot   
2020-12-02 09:53   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/108 [^]
(0124685)
hgbot   
2020-12-02 09:53   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/200 [^]
(0124686)
hgbot   
2020-12-02 09:53   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: a4249f4588f677bec114cb3b57dd1e19da886f51
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-11-30T21:32:59+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/a4249f4588f677bec114cb3b57dd1e19da886f51 [^]

Fixed BUG-45268: Fixes BP and BPLocation search using '%' operator
* Issue caused by IndexedDB changes
* Fixed by splitting the text by "%" and add separate criteria for each text

---
M web/org.openbravo.retail.posterminal/js/components/bplocation.js
M web/org.openbravo.retail.posterminal/js/components/bplocationship.js
M web/org.openbravo.retail.posterminal/js/components/businesspartner_selector.js
---