Page Comparison

...

If it returns a number greater than zero, your library is affected.

How do I fix affected ACRs?

Replace {TENANT_ID_HERE} with your tenant ID and run the following query:

UPDATE {TENANT_ID_HERE}_mod_circulation_storage.actual_cost_record
SET jsonb = jsonb_set(jsonb, '{status}', '"Open"') - 'expirationDate'
WHERE jsonb->>'status' = 'Expired'
AND jsonb->'expirationDate' IS NOT NULL
AND jsonb->'expirationDate' =  jsonb->'lossDate';

This query removes expiration date from affected ACRs and changes their status back from "Expired" to "Open".