...
ULR_users.csv: a list of user IDs that will be used to execute the script, users should be with previously generated loans.
Code Block | ||
---|---|---|
| ||
select fs09000000_mod_circulation_storage.loan.jsonb->>'userId' as user, fs09000000_mod_inventory_storage.item.jsonb->>'barcode' as itemBarcode
from fs09000000_mod_inventory_storage.item join fs09000000_mod_circulation_storage.loan
ON fs09000000_mod_inventory_storage.item.id = (fs09000000_mod_circulation_storage.loan.jsonb->>'itemId')::uuid
limit 4000 |
View MARC Tag Table (VTT)
...