Feature #83933
openTableGarbageCollectionTask should have the option to check for > 0 in expirePeriod mode
0%
Description
Currently the TableGarbageCollectionTask correctly checks if the relevant time field is greater than zero in the expireField
mode.
It should do this check also for the expirePeriod
mode. We have several cases where we currently can not use the task because of this missing check. We have rows that should be deleted, for example, 30 days after the last hit, but not if it was never hit (last_hit = 0
).
Using expireField
is not possible here because we need to wait some time before deletion and using expirePeriod
is also not possible because zero-values are not allowed to be deleted in our business-logic.
Best solution would IMHO be a setting in the task configuration of both modes, like deleteZeroValuedRows => {true, false}
(each mode with the default of the current behaviour to not introduce a breaking change).
No data to display