Report output should have a retention interval

[Jeff Davis]

By default, report output sticks around forever. Evergreen admins can always remove old output from their systems, but they don't necessarily know how long their users want to preserve the output for any given report.

I propose that each report should have a retention interval (compare bug 1672775). This would be a required field, ideally with a fairly short default value, perhaps governed by an org setting or user setting. A cronjob could be used to remove any report output that is older than the retention interval.

[Josh Stompro (u-launchpad-stompro-org)]

I think this idea makes a lot of sense. Include an org unit setting to set the default retention interval, and maybe a max interval that can be selected. Just because someone thinks that 10 years is reasonable, may not match up with an organizations data retention policies.

Let the creator of the report fine tune it if needed. Maybe a note about if longer term storage is needed, then the report should be downloaded and filed in their own records.

It may make sense to only offer pre-defined intervals also, instead of picking dates.

1 week
1 month
3 months
6 months
1 year
2 year
3 year

But then a system for defining those would be needed also.