*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
-need to review tables that keep patron data in this area
-folio_email... etc.
Purge Scripts
These are the
UPDATE folio_circulation.loan__t__
SET user_id = NULL
WHERE __current = FALSE
AND user_id IS NOT NULL
;
UPDATE folio_circulation.loan__ AS ln
SET jsonb = jsonb_set(ln.jsonb, '{userId}', 'null'::jsonb, true)
WHERE
__current = FALSE
;
Questions
What is in the zzz_ tables in Metadb? e.g., zzz___loan__t___
...