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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0052980
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminorhave not tried2023-07-17 11:062023-10-20 11:51
ReportershuehnerView Statuspublic 
Assigned ToTriage Omni WMS 
PrioritynormalResolutionfixedFixed in VersionPR24Q1
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0052980: database view m_product_warehouse_qtys_v is unused and should be removed

DescriptionChecking across:
- backoffice
- all mods/pmods
- module published in the forge

No user for this view exists except 1 reference in a unsupported 3rd party module:
USUP/src/nl.cleardrop.erpmag/src/nl/cleardrop/erpmag/ad_process/ProductInventorySyncProcess_data.xsql

Last in tree usage was apparently removed in this commit in 2016

commit 64df39054a0ac50d7da3ef5f1ddf59dd92d2ee20
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: Thu May 19 18:36:38 2016 +0200

    [pi-selector-performance] Refactor M_PRODUCT_PRICE_WAREHOUSE_V view

https://gitlab.com/openbravo/product/openbravo/-/commit/64df39054a0ac50d7da3ef5f1ddf59dd92d2ee20 [^]
Steps To ReproduceSearch (case-insensitive) for any reference of this view.
Proposed SolutionDelete the view as obsolete.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0033015 closedcaristu Performance Improvements in Product Selector 
blocks feature request 0052538 newTriage Platform Base support PostgreSQL 16 

-  Notes
(0155834)
hgbot (developer)
2023-10-13 14:33

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1018 [^]
(0155835)
hgbot (developer)
2023-10-13 14:34

Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/51 [^]
(0155977)
hgbot (developer)
2023-10-18 09:34

Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/51 [^]
(0155978)
hgbot (developer)
2023-10-18 09:34

Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: 6fce1e83b4df7dd53a620f41f054a83c99016b8d
Author: Stefan Huehner <stefan.huehner@openbravo.com>
Date: 18-10-2023 07:34:27
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/6fce1e83b4df7dd53a620f41f054a83c99016b8d [^]

ISSUE-52980: Accept API-change (removing an unused view)

---
R model/src-db/database/model/views/M_PRODUCT_WAREHOUSE_QTYS_V.xml
---
(0155979)
hgbot (developer)
2023-10-18 09:35

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1018 [^]
(0155980)
hgbot (developer)
2023-10-18 09:35

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 9341f447d5000c8fe4255a7f9d3ddd7b50a26649
Author: Stefan Huehner <stefan.huehner@openbravo.com>
Date: 18-10-2023 07:31:31
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/9341f447d5000c8fe4255a7f9d3ddd7b50a26649 [^]

Fixes ISSUE-52980: Remove unused M_PRODUCT_WAREHOUSE_QTYS_V

This view does not have any user among backoffice,mods,pmods
Modules uploaded to the forge.

Last known usage was remove in 2016 here in this commit
64df39054a0ac50d7da3ef5f1ddf59dd92d2ee20.

Remove it as obsolete.

---
R src-db/database/model/views/M_PRODUCT_WAREHOUSE_QTYS_V.xml
---
(0156115)
hgbot (developer)
2023-10-20 11:34

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 50f96db9683e7604e21bef8f1aafe9b2fdae5479
Author: Inigo Fernandez <inigo.fernandez@openbravo.com>
Date: 20-10-2023 11:34:24
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/50f96db9683e7604e21bef8f1aafe9b2fdae5479 [^]

Revert "Fixes ISSUE-52980: Remove unused M_PRODUCT_WAREHOUSE_QTYS_V"

This reverts commit 9341f447d5000c8fe4255a7f9d3ddd7b50a26649.

---
A src-db/database/model/views/M_PRODUCT_WAREHOUSE_QTYS_V.xml
---
(0156117)
hgbot (developer)
2023-10-20 11:51

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: d977d3e5a2cfcadf9fb04d0473467861001cc551
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 20-10-2023 09:51:49
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/d977d3e5a2cfcadf9fb04d0473467861001cc551 [^]

Revert "Revert "Fixes ISSUE-52980: Remove unused M_PRODUCT_WAREHOUSE_QTYS_V""

This reverts commit 50f96db9683e7604e21bef8f1aafe9b2fdae5479
---
R src-db/database/model/views/M_PRODUCT_WAREHOUSE_QTYS_V.xml
---

- Issue History
Date Modified Username Field Change
2023-07-17 11:06 shuehner New Issue
2023-07-17 11:06 shuehner Assigned To => Triage Omni WMS
2023-07-17 11:06 shuehner Modules => Core
2023-07-17 11:06 shuehner Triggers an Emergency Pack => No
2023-07-17 11:09 shuehner Relationship added related to 0033015
2023-10-13 14:33 hgbot Note Added: 0155834
2023-10-13 14:34 hgbot Note Added: 0155835
2023-10-18 09:34 hgbot Note Added: 0155977
2023-10-18 09:34 hgbot Note Added: 0155978
2023-10-18 09:35 hgbot Note Added: 0155979
2023-10-18 09:35 hgbot Resolution open => fixed
2023-10-18 09:35 hgbot Status new => closed
2023-10-18 09:35 hgbot Fixed in Version => PR24Q1
2023-10-18 09:35 hgbot Note Added: 0155980
2023-10-18 11:26 shuehner Relationship added blocks 0052538
2023-10-20 11:34 hgbot Note Added: 0156115
2023-10-20 11:51 hgbot Note Added: 0156117


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker