Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0052688 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Reporting | minor | have not tried | 2023-06-07 11:51 | 2023-06-21 08:19 | |||
| Reporter | tonialcaide | View Status | public | |||||
| Assigned To | tonialcaide | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| 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 | |||||||
| Merge Request Status | approved | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | ||||||||
| Support ticket | ||||||||
| OBNetwork customer | No | |||||||
| Regression introduced in release | ||||||||
| Summary | 0052688: Updates in reporting database | |||||||
| Description | Load 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 Reproduce | N/A | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0150864) hgbot (developer) 2023-06-07 11:59 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/43 [^] |
|
(0150984) hgbot (developer) 2023-06-09 12:47 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.distributionorder/-/merge_requests/5 [^] |
|
(0150999) hgbot (developer) 2023-06-11 16:58 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.distributionorder/-/merge_requests/5 [^] |
|
(0151413) hgbot (developer) 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 (developer) 2023-06-21 08:19 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools.sales/-/merge_requests/43 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2023-06-07 11:51 | tonialcaide | New Issue | |
| 2023-06-07 11:51 | tonialcaide | Assigned To | => tonialcaide |
| 2023-06-07 11:51 | tonialcaide | OBNetwork customer | => No |
| 2023-06-07 11:59 | hgbot | Merge Request Status | => open |
| 2023-06-07 11:59 | hgbot | Note Added: 0150864 | |
| 2023-06-08 10:20 | tonialcaide | Description Updated | View Revisions |
| 2023-06-08 10:46 | tonialcaide | Summary | Update load scripts because the created column in not correct => Updates in reporting database |
| 2023-06-08 10:46 | tonialcaide | Description Updated | View Revisions |
| 2023-06-09 12:33 | tonialcaide | Description Updated | View Revisions |
| 2023-06-09 12:47 | hgbot | Note Added: 0150984 | |
| 2023-06-11 16:58 | hgbot | Merge Request Status | open => approved |
| 2023-06-11 16:58 | hgbot | Note Added: 0150999 | |
| 2023-06-12 15:08 | tonialcaide | Description Updated | View Revisions |
| 2023-06-21 08:19 | hgbot | Resolution | open => fixed |
| 2023-06-21 08:19 | hgbot | Status | new => closed |
| 2023-06-21 08:19 | hgbot | Note Added: 0151413 | |
| 2023-06-21 08:19 | hgbot | Note Added: 0151414 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |