Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0052980 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 04. Warehouse management | minor | have not tried | 2023-07-17 11:06 | 2023-10-20 11:51 | |||
Reporter | shuehner | View Status | public | |||||
Assigned To | Triage Omni WMS | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | PR24Q1 | |||
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 | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0052980: database view m_product_warehouse_qtys_v is unused and should be removed | |||||||
Description | Checking 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 Reproduce | Search (case-insensitive) for any reference of this view. | |||||||
Proposed Solution | Delete the view as obsolete. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |||||||||||||||
|
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 |