Remove SugarBPM Processes

Does anyone have the SQL queries for removing SugarBPM process instances. I thought i had them but am unable to find them.

It would be nice if this was able to be done in the Data Archiver like  discussed: Data archiver: remove records older than x days

Parents
  • Hi John,

    Thanks for asking this.

    In Damien's post, the main challenge was not that the data can't be hard-deleted in the Data Archiver, but that there was not a dynamic filter, so a user would have to manually come in and change the before date in the filter and rerun it each time.

    I recommend using Data Archiver for your stated purpose, as it is doable there.

    Regards,
    Patrick McQueen
    Director, SugarCRM Support

Reply
  • Hi John,

    Thanks for asking this.

    In Damien's post, the main challenge was not that the data can't be hard-deleted in the Data Archiver, but that there was not a dynamic filter, so a user would have to manually come in and change the before date in the filter and rerun it each time.

    I recommend using Data Archiver for your stated purpose, as it is doable there.

    Regards,
    Patrick McQueen
    Director, SugarCRM Support

Children
  • Hello Patrick,

    Can you ensure us that all the related tables records' would be deleted as well as the pmse_inbox table ?

    We are facing an issue with one of our customer, pmse_inbox is 29Gb gross, pmse_bpm_flow 36 Gb...

    I have no solution than deleting the data step by step.

    Thanks for your feedback.

    Best regards,

    Enes