Before MODINVSTOR-987 was released, It was possible to set itemLevelCallNumberTypeId values for items that are invalid UUIDs or do not refer to a known call number type.
...
SET search_path TO {tenant}_mod_inventory_storage;
SELECT item.id AS "item id", item.jsonb ->> 'itemLevelCallNumberTypeId' AS "Call Number Type ID"
FROM item
LEFT JOIN call_number_type ON
CASE WHEN item.jsonb->>'itemLevelCallNumberTypeId' ~* '^[0-9a-z]{8}-[0-9a-z]{4}-[0-9a-z]{4}-[0-9a-z]{4}-[0-9a-z]{12}$'
THEN (item.jsonb->>'itemLevelCallNumberTypeId')::uuid = call_number_type.id
ELSE false
END
WHERE item.jsonb ->> 'itemLevelCallNumberTypeId' IS NOT NULL
AND call_number_type.id isIS nullNULL;Where {tenant} - the owner (tenant) for which you want to run the report.
...