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