Multitenant data preparation

select jsonb->'barcode' from ${tenant}_mod_inventory_storage.item   WHERE    jsonb->'status'->>'name' = 'Available' and jsonb->'barcode'!='null'  order by id asc offset 300 limit 400000

select jsonb->'barcode' from ${tenant}_mod_inventory_storage.item   WHERE    jsonb->'status'->>'name' = 'Checked out' and jsonb->'barcode'!='null'  order by id asc offset 0 limit 1500

select id from ${tenant}_mod_inventory_storage.service_point limit 1

select jsonb->'barcode' from ${tenant}_mod_users.users where jsonb->'barcode'!='null' and jsonb->'active'='true' and jsonb->'expirationDate' is null order by id asc offset 10 limit 10

select completed_date-started_date as job_time,hrid,file_name,started_date,completed_date, status, job_profile_name FROM [tenant]_mod_source_record_manager.job_execution order by started_date desc

select id from [tenant]_mod_inventory_storage.instance where creation_date >= '[started_date]' and creation_date<= '[completed_date]'

select id from ${tenant}_mod_inventory_storage.instance where creation_date >= '[started_date]' and creation_date<= '[completed_date]'

select id from ${tenant}_mod_inventory_storage.instance limit 500

select id from ${tenant}_mod_inventory_storage.instance limit 2000

select id from ${tenant}_mod_organizations_storage.organizations limit 2000

select ${tenant}_mod_finance_storage.fund.id as fundId, ${tenant}_mod_finance_storage.fund.jsonb->>'code'as fundCode from ${tenant}_mod_finance_storage.fund
join ${tenant}_mod_finance_storage.budget  
on ${tenant}_mod_finance_storage.fund.id=(${tenant}_mod_finance_storage.budget.jsonb->>'fundId')::uuid
join ${tenant}_mod_finance_storage.fiscal_year
on ${tenant}_mod_finance_storage.fiscal_year.id=(${tenant}_mod_finance_storage.budget.jsonb->>'fiscalYearId')::uuid
where ${tenant}_mod_finance_storage.fund.jsonb->>'fundStatus' = 'Active' 
and ${tenant}_mod_finance_storage.budget.jsonb->>'budgetStatus' = 'Active' 
and ${tenant}_mod_finance_storage.budget.jsonb->>'allowableEncumbrance' != '0.0' 
and ${tenant}_mod_finance_storage.budget.jsonb->>'allowableExpenditure' != '0.0' 
and (${tenant}_mod_finance_storage.fiscal_year.jsonb->>'period end)::date > CURRENT_TIMESTAMP 
limit 1

select ${tenant}_mod_finance_storage.ledger.id from ${tenant}_mod_finance_storage.ledger 
join ${tenant}_mod_finance_storage.fiscal_year
on ${tenant}_mod_finance_storage.fiscal_year.id=(${tenant}_mod_finance_storage.ledger.jsonb->>'fiscalYearOneId')::uuid 
where (${tenant}_mod_finance_storage.fiscal_year.jsonb->>'periodEnd')::date > CURRENT_TIMESTAMP

select jsonb->'barcode' from ${tenant}_mod_inventory_storage.item   WHERE    jsonb->'status'->>'name' = 'Available' and jsonb->'barcode'!='null'  order by id asc offset 0 limit 300

select ${tenant}_mod_users.users.jsonb->>'barcode' from ${tenant}_mod_circulation_storage.loan
join ${tenant}_mod_users.users on ${tenant}_mod_users.users.id = (${tenant}_mod_circulation_storage.loan.jsonb->>'userId')::uuid
join ${tenant}_mod_inventory_storage.item on ${tenant}_mod_inventory_storage.item.id = (${tenant}_mod_circulation_storage.loan.jsonb->>'itemId')::uuid
where ${tenant}_mod_inventory_storage.item.jsonb->'status'->>'name' = 'Checked out' and ${tenant}_mod_inventory_storage.item.jsonb->'barcode'!='null' 
order by (${tenant}_mod_circulation_storage.loan.jsonb->>'itemId')::uuid asc offset 1500 limit 1000  

select ${tenant}_mod_invoice_storage.invoices.jsonb->'vendorInvoiceNo'
    from ${tenant}_mod_invoice_storage.invoices limit 2000

select DISTINCT(REPLACE(text(jsonb->'name'),' ','+'))
    FROM ${tenant}_mod_organizations_storage.organizations where jsonb->>'name' not like '%,%' limit 2000

select id from ${tenant}_mod_di_converter_storage.job_profiles where jsonb->>'name' like 'Inventory Single Record - Default Create Instance'

select id from ${tenant}_mod_di_converter_storage.job_profiles where jsonb->>'name' like 'Inventory Single Record - Default Update Instance'

select id from ${tenant}_mod_inventory_storage.instance limit 3000

select id from ${tenant}_mod_copycat.profile where jsonb->>'name' like 'OCLC WorldCat'

select id from ${tenant}_mod_users.users where jsonb->'barcode'!='null' and jsonb->'active'='true' and jsonb->'expirationDate' is null order by id asc offset 0 limit 10

select id from ${tenant}_mod_inventory_storage.service_point WHERE jsonb->>'pickupLocation' = 'true'  limit 1

SELECT id
FROM (
    SELECT instance.id AS id, COUNT(DISTINCT item.jsonb->'status'->>'name') AS distinct_status_count
    FROM ${tenant}_mod_inventory_storage.instance AS instance
    JOIN ${tenant}_mod_inventory_storage.holdings_record AS holding ON instance.id = (holding.jsonb->>'instanceId')::uuid
    JOIN ${tenant}_mod_inventory_storage.item AS item ON holding.id = (item.jsonb->>'holdingsRecordId')::uuid
    GROUP BY instance.id
) AS item_instance
WHERE item_instance.distinct_status_count > 1 limit 1000;

Select jsonb->>'externalSystemId' from  ${tenant}_mod_users.users where jsonb->>'externalSystemId' is not null limit 1000