Forums - Thread Details
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 235 subscribers
  • Views 633 views
  • Users 0 members are here
Related

Data archiver: remove records older than x days

Damien Pochon
over 1 year ago

Hello,

We're trying to take advantage of the new data archiver to clean up the process list (pmse_inbox) of Sugar BPM. Our client would like to keep 6 months of process traces ("just in case"). 

None of the available filters can be used for that, and I don't want to log in their CRM every month to update the "before" field in the archiver rule. 

Any idea for a workaround? Can this list be extended like others? I'd like to avoid a custom daily job that does that. 

This project is on Ent Cloud, so it must be upgrade safe. 

Cheers,

Damien

  • 0 over 1 year ago

    I see no easy way to workaround this other than create a dedicated job:

    • the filter field is based on standard filters, they do not yet implement "x days" filters as we could find them in reports
    • the data-archiver is not accessible in BPM (I tried to put studio visible, it did not worked); it could have been a solution to modify the filter date on a regular basis.

    modifying the base filters to add the x days options is a way more heavier solution than build a simple job querying the database.

  • 0 over 1 year ago in reply to Alexandre Moulin

    Hi Alexandre, 

    I was afraid of that. And I have to say I don't understand how a cleaning mechanism does not, out of the box, have a "older than" filter... 

    In that particular project we already have a large number of jobs so Id rather spend some time developing a cutsom filter. 

    I'll create yet another support ticket. 

    Thanks for taking the time to reply!

    Damien

    Damien Pochon

    CRM & Digital consultant @ ITS4U Group

  • 0 over 1 year ago in reply to Alexandre Moulin

    So there's an enhancement request from sept 2021: portal.sugarondemand.com/

    Let's hope more partners create cases so that this case reaches perception thresholds...

    Damien Pochon

    CRM & Digital consultant @ ITS4U Group