...
Code Block |
---|
select is_deleted, count(cr.*) from cluster_record cr where not exists ( select br. from bib_record br where br.contributes_to = cr.id ) group by is_deleted; |
...
Code Block |
---|
select h.id,
h.code,
h.client_config->'ingest',
ps.process_name,
ps.process_state->'cursor'
from host_lms h, process_state ps
where h.id = ps.context;
|
Useful current status info
Code Block |
---|
select pr.id,
pr.date_created,
pr.active_workflow,
pr.patron_hostlms_code patron_system,
pr.status_code dcb_status,
pr.local_request_status pickup_request_status,
pr.local_item_id borrower_item_id,
pr.local_item_status borrower_item_status,
pr.next_scheduled_poll next_poll,
sr.local_item_status lender_item_status,
sr.local_status lender_request_status
from patron_request pr,
supplier_request sr
where sr.patron_request_id = pr.id
order by date_created;
|