Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052688ModulesReportingpublic2023-06-07 11:512023-06-21 08:19
Reportertonialcaide 
Assigned Totonialcaide 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0052688: Updates in reporting database
DescriptionLoad scripts to update:
- obrts_stock_transaction: the created column in not correct
- obrts_movements: new column reason
- obrpdio_distorderline: the created column in not correct
- obrts_storage_cur_stock: updated script due to performance reasons

Other changes:
- added column reason in table obrts_movements
- added column storage_bin_id in table obrts_storage_cur_stock
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-06-07 11:51tonialcaideNew Issue
2023-06-07 11:51tonialcaideAssigned To => tonialcaide
2023-06-07 11:51tonialcaideOBNetwork customer => No
2023-06-07 11:59hgbotMerge Request Status => open
2023-06-07 11:59hgbotNote Added: 0150864
2023-06-08 10:20tonialcaideDescription Updatedbug_revision_view_page.php?rev_id=26235#r26235
2023-06-08 10:46tonialcaideSummaryUpdate load scripts because the created column in not correct => Updates in reporting database
2023-06-08 10:46tonialcaideDescription Updatedbug_revision_view_page.php?rev_id=26236#r26236
2023-06-09 12:33tonialcaideDescription Updatedbug_revision_view_page.php?rev_id=26239#r26239
2023-06-09 12:47hgbotNote Added: 0150984
2023-06-11 16:58hgbotMerge Request Statusopen => approved
2023-06-11 16:58hgbotNote Added: 0150999
2023-06-12 15:08tonialcaideDescription Updatedbug_revision_view_page.php?rev_id=26247#r26247
2023-06-21 08:19hgbotResolutionopen => fixed
2023-06-21 08:19hgbotStatusnew => closed
2023-06-21 08:19hgbotNote Added: 0151413
2023-06-21 08:19hgbotNote Added: 0151414

Notes
(0150864)
hgbot   
2023-06-07 11:59   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/43 [^]
(0150984)
hgbot   
2023-06-09 12:47   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.distributionorder/-/merge_requests/5 [^]
(0150999)
hgbot   
2023-06-11 16:58   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.distributionorder/-/merge_requests/5 [^]
(0151413)
hgbot   
2023-06-21 08:19   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales [^]
Changeset: 6a72fdd05cd0765c6f43dcb803856e71e75815a4
Author: Toni Alcaide <antonio.alcaide@openbravo.com>
Date: 21-06-2023 06:19:04
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/commit/6a72fdd05cd0765c6f43dcb803856e71e75815a4 [^]

Fixed ISSUE-52688: Updates in reporting database - add reason, handle created differently, improve performance

---
M src-db/database/reporting-model/tables/OBRTS_MOVEMENTS.xml
M src-db/database/reporting-model/tables/OBRTS_STORAGE_CUR_STOCK.xml
M src-db/database/sourcedata/OBRPTTL_COLUMN.xml
M src-db/database/sourcedata/OBRPTTL_LOAD_SCRIPT.xml
---
(0151414)
hgbot   
2023-06-21 08:19   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/43 [^]