Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0052751 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Modules] Reporting | minor | have not tried | 2023-06-15 12:55 | 2023-06-16 10:13 | |||
| 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 | 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  suggestion for change.png [^] (487,051 bytes) 2023-06-15 12:55 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0151225) hgbot (developer) 2023-06-15 17:05 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/18 [^] |
|
(0151235) hgbot (developer) 2023-06-16 00:01 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.reporting.tools/-/merge_requests/18 [^] |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |