Flat Report Data Purge Group Questions

If one was to define a table as being part of the Flat Report Data purge group, please could you let me know the following:

  • Must the table form part of a report execution or can it be a standalone table which just needs to be purged regularly?
  • Can I confirm the purge runs every 72 hours still (basing this on this thread: How long are report executions retained?)
  • What is the criteria of the Flat Report Data group i.e what is the filter to determine which records will be purged (if any)? When the purge runs, does it clear the entire table or based on the age of the record?
  • I didn’t see the Flat Report Data purge group in the list of Purge Configuration Setup app - can I confirm it will still run as it’s a NW delivered group?

Thank you.

I believe that what you’re suggesting will work, but as you’ve noticed, it’s very opaque and isn’t exactly how the purge group was intended to be used.

The recommended approach would be to use Data Purge instead. In the app “Data Purge Definitions”, you can set up instructions for purging your table. To make it run regularly, you can then set up a “Job Scheduler” to execute the logic block DataPurgeExecutePurgeWrapper against your data purge regularly. This way, you can control exactly when and how the data is purged.

Going forward, I expect this to be the recommendation for all purges, even ones that would have previously fallen into the “purge group” use case.

2 Likes