Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045288Retail ModulesWeb POSpublic2020-10-22 16:062020-11-16 06:50
Reportermarvintm 
Assigned Toranjith_qualiantech_com 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
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
Summary0045288: MultiUPC module doesn't work correctly when scanning if many products are available in local mode
DescriptionCurrently multiupc module has a problem with the IndexedDB changes. The query to scan requires using the IndexedDB cache, as it is using the 'includes' operator and that makes it incompatible with the IndexedDB native indices.

However, the cache takes a bit of time when the number of products is large. This means that while it is being initialised, the query will fail. The reason is that the file extendUPCSearch.js is checking the remote mode using the hasPermission API, instead of using the OB.UTIL.remoteSearch API
Steps To ReproduceConfigure a system with multiupc module, and a large (>100k) number of products.
Log in the WebPOS and try to scan using a multiupc code. Notice that the query doesn't find any product.
Wait a few seconds/minutes, try again and notice that it works now (because cache was initialized)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0048054 closed ranjith_qualiantech_com Products with multiple UPC/EAN not found in Web POS 
Attached Filesdiff patch1.diff (2,131) 2020-10-22 16:42
https://issues.openbravo.com/file_download.php?file_id=15038&type=bug
diff patch2.diff (708) 2020-10-22 16:42
https://issues.openbravo.com/file_download.php?file_id=15039&type=bug
diff patch3.diff (933) 2020-10-22 16:42
https://issues.openbravo.com/file_download.php?file_id=15040&type=bug
Issue History
Date ModifiedUsernameFieldChange
2020-10-22 16:06marvintmNew Issue
2020-10-22 16:06marvintmAssigned To => Retail
2020-10-22 16:06marvintmTriggers an Emergency Pack => No
2020-10-22 16:42AugustoMauchFile Added: patch1.diff
2020-10-22 16:42AugustoMauchFile Added: patch2.diff
2020-10-22 16:42AugustoMauchFile Added: patch3.diff
2020-10-28 20:06ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2020-10-29 07:48ranjith_qualiantech_comStatusnew => scheduled
2020-11-10 03:42hgbotNote Added: 0124247
2020-11-16 06:50hgbotResolutionopen => fixed
2020-11-16 06:50hgbotStatusscheduled => closed
2020-11-16 06:50hgbotNote Added: 0124381
2020-11-16 06:50hgbotNote Added: 0124382
2021-12-31 06:52ranjith_qualiantech_comRelationship addedrelated to 0048054

Notes
(0124247)
hgbot   
2020-11-10 03:42   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/4 [^]
(0124381)
hgbot   
2020-11-16 06:50   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc [^]
Changeset: f893ea068ffe4181d970fd4f0bac3189115e2c0a
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2020-11-16T05:49:53+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/commit/f893ea068ffe4181d970fd4f0bac3189115e2c0a [^]

Fixed ISSUE-45288: Removed Cache query when searching multi upc
For larger data, cache query was taking time to initialize

---
M web/org.openbravo.retail.multiupc/js/extendUPCSearch.js
M web/org.openbravo.retail.multiupc/js/multiupc.js
---
(0124382)
hgbot   
2020-11-16 06:50   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/4 [^]