Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0049681 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2022-06-29 13:52 | 2022-08-30 12:30 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR22Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0049681: With big volumes the Verify Return selector is very slow when no filter is used | |||||||
| Description | In a customer with a big volume of data, if Verify Return selector is used without any filter (Document Number filter is empty), the query is taking for more than 1 min. The Verify Return search is returning only 301 records ordered by updated date, but the query is taking count all records | |||||||
| Steps To Reproduce | . in customer with a big volume of data . open Verify Return selector . click in search button > 1min later: 301 records are returned ordered by updated | |||||||
| Proposed Solution | . if no filter is used, we should include one filter by the last X days. it has no sense, without filters, search in receipts for more than several months or years, and return only the 301 newer records. | |||||||
| Tags | Performance | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0139258) hgbot (developer) 2022-07-12 07:16 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/853 [^] |
|
(0139576) hgbot (developer) 2022-07-25 09:22 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: 9d8c7ca9bd1b304fb291fc7341f89e67ae215aca Author: Ranjith S R <ranjith@qualiantech.com> Date: 25-07-2022 07:21:44 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/9d8c7ca9bd1b304fb291fc7341f89e67ae215aca [^] Fixed ISSUE-49681: Added OrderDateFilter in PaidReceiptFilter * In PaidReceiptFilter, if ther is no remote filter, then order should be filtered by orderDate by past 30 days. Filter 30 days can be changed by preference "Web POS Paid Receipts OrderDate Filter Days" --- M src-db/database/sourcedata/AD_PREFERENCE.xml M src-db/database/sourcedata/AD_REF_LIST.xml M src/org/openbravo/retail/posterminal/PaidReceiptsFilter.java --- |
|
(0139577) hgbot (developer) 2022-07-25 09:22 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/853 [^] |
|
(0140501) hgbot (developer) 2022-08-30 12:30 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: cbb2215d93eb312b3f10479a7947bf6a75690abf Author: Ranjith S R <ranjith@qualiantech.com> Date: 30-08-2022 15:59:08 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/cbb2215d93eb312b3f10479a7947bf6a75690abf [^] Related to ISSUE-49681: Updated OrderDate filter days in PaidReceipt * Increased OrderDate filter days to 3650 --- M src-db/database/sourcedata/AD_PREFERENCE.xml --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2022-06-29 13:52 | malsasua | New Issue | |
| 2022-06-29 13:52 | malsasua | Assigned To | => Retail |
| 2022-06-29 13:52 | malsasua | Triggers an Emergency Pack | => No |
| 2022-06-29 14:16 | malsasua | Tag Attached: Performance | |
| 2022-06-29 14:22 | malsasua | Relationship added | related to 0049683 |
| 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-08 14:22 | hector_hernaez | Issue Monitored: hector_hernaez | |
| 2022-07-12 07:16 | hgbot | Note Added: 0139258 | |
| 2022-07-25 09:21 | hgbot | Resolution | open => fixed |
| 2022-07-25 09:21 | hgbot | Status | scheduled => closed |
| 2022-07-25 09:22 | hgbot | Fixed in Version | => RR22Q4 |
| 2022-07-25 09:22 | hgbot | Note Added: 0139576 | |
| 2022-07-25 09:22 | hgbot | Note Added: 0139577 | |
| 2022-08-30 12:30 | hgbot | Note Added: 0140501 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |