Page History

...

This query replaces the requester_id value with NULL on the request__t__ table if the request status is Closed or the request row is historical:

UPDATE folio_circulation.request__t__
SET requester_id = NULL
WHERE status LIKE 'Closed%'
OR request__t__.__current = false
;

This query replaces the requester_id value with NULL on the request__t table if the request status is Closed:

UPDATE folio_circulation.request__t
SET requester_id = NULL
WHERE status LIKE 'Closed%'
;

This query replaces barcode, firstName, lastName, and middleName fields inside the requester object with NULL and replaces the requesterId value with NULL if request status is Closed or request row is historical:

...