Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049683Retail ModulesWeb POSpublic2022-06-29 14:222022-11-22 11:12
Reportermalsasua 
Assigned Toranjith_qualiantech_com 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR22Q4 
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
Summary0049683: With big volumes the Verify Return selector is very slow using "contains" operator in document number
DescriptionIn a customer with a big volume of data, if Verify Return selector is used with document number filter and "contains" operator (instead of "equal"), the selector is very slow.
Steps To Reproduce. in customer with a big volume of data
. open Verify Return selector
. in filter text area: "1"
. click in search button
> the selector is taking several seconds in the response
Proposed Solution. the index
"em_obpos_order_docno_trgm" gin (upper(documentno::text) gin_trgm_ops)
is not used

In this link, you can check the explain plan:

https://explain.depesz.com/s/2Ov6 [^]
Additional Information
TagsPerformance
Relationships
related to defect 0049681 closed ranjith_qualiantech_com With big volumes the Verify Return selector is very slow when no filter is used 
Attached Filestxt conFiltro.txt (1,970) 2022-06-29 16:59
https://issues.openbravo.com/file_download.php?file_id=17258&type=bug
Issue History
Date ModifiedUsernameFieldChange
2022-06-29 14:22malsasuaNew Issue
2022-06-29 14:22malsasuaAssigned To => Retail
2022-06-29 14:22malsasuaTriggers an Emergency Pack => No
2022-06-29 14:22malsasuaTag Attached: Performance
2022-06-29 14:22malsasuaRelationship addedrelated to 0049681
2022-06-29 16:59malsasuaFile Added: conFiltro.txt
2022-07-05 07:39ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2022-07-05 07:39ranjith_qualiantech_comStatusnew => scheduled
2022-07-25 04:36hgbotNote Added: 0139563
2022-07-25 04:36hgbotNote Added: 0139564
2022-08-09 08:19hgbotResolutionopen => fixed
2022-08-09 08:19hgbotStatusscheduled => closed
2022-08-09 08:19hgbotNote Added: 0139987
2022-08-09 08:19hgbotFixed in Version => RR22Q4
2022-08-09 08:19hgbotNote Added: 0139988
2022-08-09 08:19hgbotNote Added: 0139989
2022-08-09 08:19hgbotNote Added: 0139990
2022-11-22 11:12hgbotNote Added: 0143993

Notes
(0139563)
hgbot   
2022-07-25 04:36   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/872 [^]
(0139564)
hgbot   
2022-07-25 04:36   
Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/213 [^]
(0139987)
hgbot   
2022-08-09 08:19   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/872 [^]
(0139988)
hgbot   
2022-08-09 08:19   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 562317b69980682e88c357ca90ddd89f92282637
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 08-08-2022 10:57:38
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/562317b69980682e88c357ca90ddd89f92282637 [^]

Fixed ISSUE-49683: Added Filter validation for Order Selector
* When searching for the open receipt & verified return,
  if filter has less than 3 characters, then warning should be shown
* Remote Filters should be validated if
  Pref. "Use Contains in Receipt Search" is disabled

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/retail/posterminal/PaidReceiptsFilter.java
M web/org.openbravo.retail.posterminal/js/components/modal-pay-open-tickets.js
M web/org.openbravo.retail.posterminal/js/components/modalorderselector.js
---
(0139989)
hgbot   
2022-08-09 08:19   
Merge request merged: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/213 [^]
(0139990)
hgbot   
2022-08-09 08:19   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: bed88cb607a3078dcdd246309600a4a1cda7e1e5
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 09-08-2022 06:19:39
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/bed88cb607a3078dcdd246309600a4a1cda7e1e5 [^]

Verifies ISSUE-49683: Updated Automated Tests

---
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/creditnote/CreateCreditNoteWithAnonymous.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/crossstore/CrossStoreUIOpenReceipt.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/crossstore/CrossStoreUIVerifiedReturns.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/crossstore/InStoreUIOpenReceipt.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/crossstore/InStoreUIVerifiedReturns.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/layaway/I34354_VerifyVoidLayawayInList.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/orderselector/VerifyOrderSelector.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I38739_OpenMultipleReceipts.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/sales/I30839_SalesVerifyDateInOracle.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I31212_SearchWithLimitPref.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I32669_VerifyUIUnPaidReceiptList.java
---
(0143993)
hgbot   
2022-11-22 11:12   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: 1003572d3919d74ee64dd4913b3e7394cbdadc26
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 22-11-2022 15:42:23
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/1003572d3919d74ee64dd4913b3e7394cbdadc26 [^]

Verifies ISSUE-49683: Updated Automated Tests

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/layaway/LayawayNotListedWhenFinished.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/VerifyCreationDateIsInISOFormat.java
---