Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformmajorhave not tried2019-04-25 16:422019-04-25 16:42
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0040685: Create a purge script to remove data from an Openbravo database enforcing referencial integrity

DescriptionSome 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-
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker