Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0049683
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2022-06-29 14:222022-11-22 11:12
ReportermalsasuaView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityhighResolutionfixedFixed in VersionRR22Q4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0049683: 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 [^]
TagsPerformance
Attached Filestxt file icon conFiltro.txt [^] (1,970 bytes) 2022-06-29 16:59 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0049681 closedranjith_qualiantech_com With big volumes the Verify Return selector is very slow when no filter is used 

-  Notes
(0139563)
hgbot (developer)
2022-07-25 04:36

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/872 [^]
(0139564)
hgbot (developer)
2022-07-25 04:36

 Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/213 [^]
(0139987)
hgbot (developer)
2022-08-09 08:19

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/872 [^]
(0139988)
hgbot (developer)
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 (developer)
2022-08-09 08:19

 Merge request merged: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/213 [^]
(0139990)
hgbot (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2022-06-29 14:22 malsasua New Issue
2022-06-29 14:22 malsasua Assigned To => Retail
2022-06-29 14:22 malsasua Triggers an Emergency Pack => No
2022-06-29 14:22 malsasua Tag Attached: Performance
2022-06-29 14:22 malsasua Relationship added related to 0049681
2022-06-29 16:59 malsasua File Added: conFiltro.txt
2022-07-05 07:39 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2022-07-05 07:39 ranjith_qualiantech_com Status new => scheduled
2022-07-25 04:36 hgbot Note Added: 0139563
2022-07-25 04:36 hgbot Note Added: 0139564
2022-08-09 08:19 hgbot Resolution open => fixed
2022-08-09 08:19 hgbot Status scheduled => closed
2022-08-09 08:19 hgbot Note Added: 0139987
2022-08-09 08:19 hgbot Fixed in Version => RR22Q4
2022-08-09 08:19 hgbot Note Added: 0139988
2022-08-09 08:19 hgbot Note Added: 0139989
2022-08-09 08:19 hgbot Note Added: 0139990
2022-11-22 11:12 hgbot Note Added: 0143993

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker