Purpose
Job made for cleaning personal data of persons in merge requests.
Job logic
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 updated_at >= current_datetime() - MERGE_REQUEST_DATA_EXPIRATION_DAYS. Then skip the record
If updated_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
updated_at - date and time when status was set. Can be obtained from event data (Event manager DB).