Page Comparison

...

1. Job starts once in 24 hours by default (configured parameter PREPERSON_MERGE_REQUEST_SCHEDULE).

2. After starting it gets value from global parameter PREPERSON_MERGE_REQUEST_EXPIRATION.

3. Select all entries from il.merge_requests with status=NEW or APPROVED:

   1. If inserted_at >= current_datetime() - PREPERSON_MERGE_REQUEST_EXPIRATION. Then skip the record

   2. If inserted_at < current_datetime() - PREPERSON_MERGE_REQUEST_EXPIRATION. Then update entry:

      1. set status = EXPIRED

      2. set updated_at = current_datetime()

      3. set updated_by = system_user()

      4. for APPROVED preperson merge request anonymize clean person data