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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0045144
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2020-09-25 12:212020-11-02 07:22
ReporterrafarodaView Statuspublic 
Assigned Toprakashmurugesan88 
PriorityhighResolutionfixedFixed in Version
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

0045144: Fix incremental and full refresh with Multi Tax Category module

DescriptionFix incremental and full refresh with Multi Tax Category module

Steps To ReproduceWith Multi Tax Category module, the incremental and full refresh queries are slow
Proposed SolutionAs discussed with Antonio:
* A new field will be created to indicate in Organization Level the tax organization
* A new preference to make use of that organization

This will allow the incremental refresh and full refresh queries to look for the proper tax organization directly instead of the organization tree to make it faster
TagsNOR
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0045055 closedranjith_qualiantech_com Retail Modules Incremental refresh of ProductCharacteristic cannot use index on updated 
related to defect 0044911 closedranjith_qualiantech_com Retail Modules Incremental refresh of Product cannot use index on updated 
related to defect 0044590 closedranjith_qualiantech_com Retail Modules Product tax category changes are not updated in webpos 
related to feature request 0045056 newRetail Retail Modules Faster insertion of big amounts of data in full refresh in indexedDB 
related to defect 0045187 closedranjith_qualiantech_com Retail Modules Full Refresh fail: continues the load when it should stop 
related to defect 0045248 closedprakashmurugesan88 Retail Modules Copy store does not copy field Organization Tax Category from Organization window 
related to defect 0045467 closedprakashmurugesan88 Retail Modules Performance issues on the model CharacteristicValue 
related to defect 0045919 closedrqueralta Retail Modules Extra join of product table in master.product 
related to design defect 0045922 acknowledgedTriage Platform Base Openbravo ERP Extra self-join with main table when using computed columns 

-  Notes
(0123978)
hgbot (developer)
2020-10-28 14:53

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/3 [^]
(0124012)
hgbot (developer)
2020-10-29 15:40

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: ba9d028171eed6edd81aa2f47fa9c213eedf93ec
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-28T19:18:26+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/ba9d028171eed6edd81aa2f47fa9c213eedf93ec [^]

Related to BUG-45144: Added Organization tax category to improve full and incremental refresh

---
M src/org/openbravo/retail/multitaxcategory/master/TaxCategoryLoadedProductProperties.java
M src/org/openbravo/retail/multitaxcategory/master/TaxCategoryProductProperties.java
---
(0124013)
hgbot (developer)
2020-10-29 15:40

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: 648605ebc621e37aa1265c830958250ba276e846
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-28T19:18:51+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/648605ebc621e37aa1265c830958250ba276e846 [^]

Related to BUG-45144: Added Organization tax category to improve full and incremental refresh

---
A src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_PREFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
---
(0124014)
hgbot (developer)
2020-10-29 15:40

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: 25cf289c1a0d2c0ab34dbec530fa4637bb249298
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-28T19:19:38+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/25cf289c1a0d2c0ab34dbec530fa4637bb249298 [^]

Fixed BUG-45144: Fixes model issues

---
A src-db/database/model/modifiedTables/AD_ORG.xml
A src-db/database/sourcedata/AD_COLUMN.xml
A src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/retail/multitaxcategory/master/TaxCategoryLoadedProductProperties.java
M src/org/openbravo/retail/multitaxcategory/master/TaxCategoryProductProperties.java
---
(0124015)
hgbot (developer)
2020-10-29 15:40

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/3 [^]
(0124029)
hgbot (developer)
2020-10-30 07:17

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: a82041b5deabfd17d68562237ff01196310fa472
Author: Antonio Moreno <anmorenoperez@gmail.com>
Date: 2020-10-30T07:17:35+01:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/a82041b5deabfd17d68562237ff01196310fa472 [^]

Related to BUG-45144: Added missing FK

---
M src-db/database/model/modifiedTables/AD_ORG.xml
---
(0124074)
hgbot (developer)
2020-11-02 06:20

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/4 [^]
(0124079)
hgbot (developer)
2020-11-02 07:22

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory [^]
Changeset: 5a36711664d82f56a92295bfb1aae8e08be1a1d9
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-10-30T18:42:51+05:30
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/commit/5a36711664d82f56a92295bfb1aae8e08be1a1d9 [^]

Fixed BUG-45144: Fixed selector reference to list only natural org tree in Organization Tax Category field

---
A src-db/database/sourcedata/AD_REFERENCE.xml
A src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0124080)
hgbot (developer)
2020-11-02 07:22

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multitaxcategory/-/merge_requests/4 [^]

- Issue History
Date Modified Username Field Change
2020-09-25 12:21 rafaroda New Issue
2020-09-25 12:21 rafaroda Assigned To => marvintm
2020-09-25 12:21 rafaroda Resolution time => 1602280800
2020-09-25 12:21 rafaroda Triggers an Emergency Pack => No
2020-09-25 12:21 rafaroda Tag Attached: NOR
2020-09-25 12:22 rafaroda Relationship added related to 0045055
2020-09-25 12:22 rafaroda Relationship added related to 0044911
2020-09-25 12:23 rafaroda Relationship added related to 0044590
2020-09-25 12:23 rafaroda Relationship added related to 0045056
2020-09-28 07:32 marvintm Assigned To marvintm => Retail
2020-10-05 07:10 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2020-10-05 08:45 ranjith_qualiantech_com Assigned To ranjith_qualiantech_com => Retail
2020-10-05 11:36 rafaroda Relationship added related to 0045187
2020-10-07 09:13 marvintm Resolution time 1602280800 => 1602885600
2020-10-14 08:56 marvintm Resolution time 1602885600 => 1603490400
2020-10-19 14:55 rafaroda Relationship added related to 0045248
2020-10-22 07:47 marvintm Resolution time 1603490400 => 1604962800
2020-10-28 14:53 hgbot Note Added: 0123978
2020-10-29 15:39 marvintm Assigned To Retail => prakashmurugesan88
2020-10-29 15:39 marvintm Status new => scheduled
2020-10-29 15:40 hgbot Note Added: 0124012
2020-10-29 15:40 hgbot Note Added: 0124013
2020-10-29 15:40 hgbot Resolution open => fixed
2020-10-29 15:40 hgbot Status scheduled => closed
2020-10-29 15:40 hgbot Note Added: 0124014
2020-10-29 15:40 hgbot Note Added: 0124015
2020-10-30 07:17 hgbot Note Added: 0124029
2020-11-02 06:20 hgbot Note Added: 0124074
2020-11-02 07:22 hgbot Note Added: 0124079
2020-11-02 07:22 hgbot Note Added: 0124080
2021-02-22 09:33 rafaroda Relationship added related to 0045467
2021-02-22 10:47 rafaroda Relationship added related to 0045919
2021-02-22 10:47 rafaroda Relationship added related to 0045922


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker