Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0040685 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] A. Platform | major | have not tried | 2019-04-25 16:42 | 2019-04-25 16:42 | |||||||
| Reporter | AugustoMauch | View Status | public | |||||||||
| Assigned To | AugustoMauch | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | 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 | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0040685: Create a purge script to remove data from an Openbravo database enforcing referencial integrity | |||||||||||
| Description | Some Openbravo clients accumulate a lot of transactional data, that they no longer need to be stored in the Openbravo database anymore because it is stored somewhere else (i.e. SAP or any other external system). It would be useful to provide a script that removes data from transactional data tables, removing recursively records referenced by them to make sure referential integrity is maintained. The input of the script could be for instance a root table (i.e. OBPOS_APP_CASHUP and a where clause (i.e. to select cashups created before 2016). The script should be able to remove data referencing removed rows by checking the foreign keys in the catalog. | |||||||||||
| Steps To Reproduce | - | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2019-04-25 16:42 | AugustoMauch | New Issue | |
| 2019-04-25 16:42 | AugustoMauch | Assigned To | => AugustoMauch |
| 2019-04-25 16:42 | AugustoMauch | Modules | => Core |
| 2019-04-25 16:42 | AugustoMauch | Triggers an Emergency Pack | => No |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |