Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0052751 | Modules | Reporting | public | 2023-06-15 12:55 | 2023-06-16 10:13 |
|
| Reporter | tonialcaide | |
| Assigned To | tonialcaide | |
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | merged |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | mtaal |
| Support ticket | |
| OBNetwork customer | No |
| Regression introduced in release | |
|
| Summary | 0052751: Adding the timestamp_value of the refresh done for materialized views in the obrpttl_parameters table |
| Description | Hello team,
We need to be able to monitor when a certain materialized view (mv) was correctly refreshed last time in the reporting database.
The behavior already exists for tables: as soon as a table is refreshed, the column timestamp_value is updated in the obrpttl_parameters table, for that precise record that is corresponding to the table’s name.
We need to have the same behavior for mv’s.
Here is the class used to refresh data in mv:
/mnt/ob_data/OpenbravoERP/modules/org.openbravo.reporting.tools/src/org/openbravo/reporting/tools/dataloader/MaterializedViewDataLoader.java
And here is the class used to refresh data in tables:
/mnt/ob_data/OpenbravoERP/modules/org.openbravo.reporting.tools/src/org/openbravo/reporting/tools/dataloader/StandardDataLoader.java
I add enclosed a suggestion of the place where change could be done, please adapt whatever is needed.
Regards,
Ludmila
|
| Steps To Reproduce | N/A |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  suggestion for change.png (487,051) 2023-06-15 12:55
https://issues.openbravo.com/file_download.php?file_id=18648&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2023-06-15 12:55 | tonialcaide | New Issue | |
| 2023-06-15 12:55 | tonialcaide | Assigned To | => tonialcaide |
| 2023-06-15 12:55 | tonialcaide | File Added: suggestion for change.png | |
| 2023-06-15 12:55 | tonialcaide | OBNetwork customer | => No |
| 2023-06-15 17:05 | hgbot | Merge Request Status | => open |
| 2023-06-15 17:05 | hgbot | Note Added: 0151225 | |
| 2023-06-16 00:01 | hgbot | Merge Request Status | open => merged |
| 2023-06-16 00:01 | hgbot | Note Added: 0151235 | |
| 2023-06-16 10:12 | tonialcaide | Status | new => scheduled |
| 2023-06-16 10:12 | tonialcaide | Resolution | open => fixed |
| 2023-06-16 10:13 | tonialcaide | Status | scheduled => resolved |
| 2023-06-16 10:13 | tonialcaide | Review Assigned To | => mtaal |
| 2023-06-16 10:13 | tonialcaide | Status | resolved => closed |