Project

General

Profile

Actions

Feature #83933

open

TableGarbageCollectionTask should have the option to check for > 0 in expirePeriod mode

Added by Stefan P over 6 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
scheduler
Target version:
-
Start date:
2018-02-16
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

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

Actions

Also available in: Atom PDF