Versions Compared

Old Version 3

changes.mady.by.user Serhii Tatarenko (NHSU partner, Edenlab)

Saved on

compared with

New Version 4

changes.mady.by.user Serhii Tatarenko (NHSU partner, Edenlab)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

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

  3. Select all entries from mpi.merge_person_preperson_request with status=NEW:

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

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

      1. set status = EXPIRED

      2. set updated_at = current_datetime()

      3. set updated_by = system_user()