Bonita_history - SQL query to delete instances

Q&A
1

Hello,

Im using bonita 5.4.1 with tomcat bundle, i know it’s a old version, and we have bonita installed in production environment for 4 years i believe.

We have a lot of finished processes instances and we need to delete them without using the bonita console.

Is there any sql query so we can use to delete instances from bonita_history that are older than a year or so?

Thanks

2

Simply put, No.

It would be much better to write a process with a script connector to Delete the Archived processes the right way. This way you know the system will clean up after itself and, hopefully, leave no hanging (chads) artifacts.

regards
Seán

PS: If this reply answers your question, please mark as resolved.

3

Thanks for the answer.

You have any example of a script to do that? I need to delete archive processes ended before last year.

Thanks for the help

4

Nope sorry, we’re prohibited by law from deleting anything.

regards