...
Job starts once in 24 hours by default (configured parameter MERGE_REQUEST_AUTOCLEANING_SCHEDULE).
After starting it gets value from global parameter MERGE_REQUEST_DATA_CLEANING
Select all entries from il.merge_requests with status=EXPIRED, REJECTED, SIGNED:
If updated_at >= current_datetime() - MERGE_REQUEST_DATA_CLEANING. Then skip the record
If updated_at < current_datetime() - MERGE_REQUEST_DATA_CLEANING. 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 | ||
---|---|---|
| ||
updated_at - date and time when status was set |