Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045760Retail ModulesWeb POSpublic2021-01-20 10:262021-08-26 08:49
Reporterlorenzofidalgo 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionmain 
Target VersionFixed in VersionRR21Q4 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customer
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2020-07-06
Regression introduced in releaseRR20Q3
Regression introduced by commithttps://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/commit/92f6a2aedeb9627e3a2d99537c885f496035eb21 [^]
Triggers an Emergency PackNo
Summary0045760: [21Q1] With MultiUPC, on product SEARCH, operator '%' does not work properly
DescriptionIt is supposed you can use the character "%" as wildcard when you are searching for a product in SEARCH tab. It has a conflict with MultiUPC and does not work.
Steps To Reproduce0-With MultiUPC enabled, login POS as vallblanca.
1-Tap SEATCH tab and enter "adhesive%warmer" string and click search button. DEFECT: It does not find any product (check attached image)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0045268 closed prakashmurugesan88 On Product SEARCH, operator '%' has stopped working 
depends on backport 0047594RR21Q3.1 closed ranjith_qualiantech_com [21Q1] With MultiUPC, on product SEARCH, operator '%' does not work properly 
depends on backport 0047595RR21Q2.2 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 Filespng NoProductsFound.png (142,118) 2021-01-20 10:26
https://issues.openbravo.com/file_download.php?file_id=15267&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2021-01-20 10:26lorenzofidalgoNew Issue
2021-01-20 10:26lorenzofidalgoAssigned To => Retail
2021-01-20 10:26lorenzofidalgoFile Added: NoProductsFound.png
2021-01-20 10:26lorenzofidalgoTriggers an Emergency Pack => No
2021-01-20 10:26lorenzofidalgoRelationship addedrelated to 0045268
2021-07-29 18:17PracticsIssue Monitored: Practics
2021-07-30 09:14adrianromeroStatusnew => scheduled
2021-07-30 09:23guilleaerResolution time => 1628028000
2021-07-30 09:48guilleaerRegression level => Production - Confirmed Stable
2021-07-30 09:48guilleaerRegression date => 2020-07-06
2021-07-30 09:48guilleaerRegression introduced in release => RR20Q3
2021-07-30 09:48guilleaerRegression introduced by commit => https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/commit/92f6a2aedeb9627e3a2d99537c885f496035eb21 [^]
2021-07-30 11:39adrianromeroAssigned ToRetail => ranjith_qualiantech_com
2021-07-30 11:45adrianromeroNote Added: 0130892
2021-08-02 09:44adrianromeroNote Added: 0130923
2021-08-03 13:33hgbotNote Added: 0130949
2021-08-03 14:37hgbotResolutionopen => fixed
2021-08-03 14:37hgbotStatusscheduled => closed
2021-08-03 14:37hgbotNote Added: 0130953
2021-08-03 14:37hgbotNote Added: 0130954
2021-08-05 18:17adrianromeroRelationship addedrelated to 0047441
2021-08-26 08:49marvintmStatusclosed => new
2021-08-26 08:49marvintmResolutionfixed => open
2021-08-26 08:49marvintmStatusnew => scheduled
2021-08-26 08:49marvintmStatusscheduled => resolved
2021-08-26 08:49marvintmFixed in Version => RR21Q4
2021-08-26 08:49marvintmResolutionopen => fixed
2021-08-26 08:49marvintmReview Assigned To => adrianromero
2021-08-26 08:49marvintmStatusresolved => closed

Notes
(0130892)
adrianromero   
2021-07-30 11:45   
This regression is a consequence of the migration of WebSQL to IndexedDB

The filter created by MultiUPC for products should use textCriterion() instead of multiCriterion() in order to be able to filter using the wildcard character "%"
(0130923)
adrianromero   
2021-08-02 09:44   
Issue must be fixed in the current master branch and provide a patch for 21Q1. I assume the patch should be a straightforward to create.
(0130949)
hgbot   
2021-08-03 13:33   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/9 [^]
(0130953)
hgbot   
2021-08-03 14:37   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc [^]
Changeset: 77a760569252acf47f91d6b15491e828895fde56
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2021-08-03T11:57:34+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/commit/77a760569252acf47f91d6b15491e828895fde56 [^]

Fixed ISSUE-45760: Added TextCriterion for Product search
* For searching with %, multiCriterion is replaced with textCriterion

---
M web/org.openbravo.retail.multiupc/js/extendUPCSearch.js
---
(0130954)
hgbot   
2021-08-03 14:37   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/9 [^]