Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052980Openbravo ERP04. Warehouse managementpublic2023-07-17 11:062023-10-20 11:51
Reportershuehner 
Assigned ToTriage Omni WMS 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR24Q1 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0052980: 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.
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0033015 closed caristu Performance Improvements in Product Selector 
blocks feature request 0052538 new Triage Platform Base support PostgreSQL 16 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-07-17 11:06shuehnerNew Issue
2023-07-17 11:06shuehnerAssigned To => Triage Omni WMS
2023-07-17 11:06shuehnerOBNetwork customer => No
2023-07-17 11:06shuehnerModules => Core
2023-07-17 11:06shuehnerTriggers an Emergency Pack => No
2023-07-17 11:09shuehnerRelationship addedrelated to 0033015
2023-10-13 14:33hgbotMerge Request Status => open
2023-10-13 14:33hgbotNote Added: 0155834
2023-10-13 14:34hgbotNote Added: 0155835
2023-10-18 09:34hgbotMerge Request Statusopen => approved
2023-10-18 09:34hgbotNote Added: 0155977
2023-10-18 09:34hgbotNote Added: 0155978
2023-10-18 09:35hgbotNote Added: 0155979
2023-10-18 09:35hgbotResolutionopen => fixed
2023-10-18 09:35hgbotStatusnew => closed
2023-10-18 09:35hgbotFixed in Version => PR24Q1
2023-10-18 09:35hgbotNote Added: 0155980
2023-10-18 11:26shuehnerRelationship addedblocks 0052538
2023-10-20 11:34hgbotNote Added: 0156115
2023-10-20 11:51hgbotNote Added: 0156117

Notes
(0155834)
hgbot   
2023-10-13 14:33   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1018 [^]
(0155835)
hgbot   
2023-10-13 14:34   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/51 [^]
(0155977)
hgbot   
2023-10-18 09:34   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/51 [^]
(0155978)
hgbot   
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   
2023-10-18 09:35   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1018 [^]
(0155980)
hgbot   
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   
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   
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
---