Forums - Thread Details
  • State Suggested Answer
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 234 subscribers
  • Views 282 views
  • Users 0 members are here
Related

Remove SugarBPM Processes

John Boyes
12 days ago

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
  • 0 11 days ago

    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
  • 0 11 days ago

    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
  • 0 11 days ago in reply to Patrick McQueen

    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