...
Job starts once in 24 hours by default (configured parameter MERGE_REQUEST_AUTOCLEANING_SCHEDULE = “0 0 */1 * *“ by default).
After starting it gets value from global parameter MERGE_REQUEST_DATA_EXPIRATION_DAYS ( by default 1 day)
Select all entries from il.merge_requests with status=EXPIRED, REJECTED, SIGNED:
If updatedinserted_at >= current_datetime() - MERGE_REQUEST_DATA_EXPIRATION_DAYS. Then skip the record
If updatedinserted_at < current_datetime() - MERGE_REQUEST_DATA_EXPIRATION_DAYS. Then update entry:
set fields data, authentication_method_current, printout_form to null.
set updated_by to system user.
set updated_at to current datetime.
...
Note
...
.