...
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;
|