Versions Compared

Old Version 4

changes.mady.by.user Jag Goraya

Saved on

compared with

New Version 5

changes.mady.by.user Jag Goraya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
update location set agency_fk = 'cb297647-c6f9-591c-9e8b-c58dfea986a9'
where host_system_id = 'eb745468-c69c-5f7e-9bd4-cf3cf8db6cd9'

Checking polling schedule

Code Block
languagesql
select pr.id, pr.date_created, pr.active_workflow, pr.patron_hostlms_code, pr.status_code, pr.local_request_status, pr.local_item_id, pr.local_item_status, pr.next_scheduled_poll, sr.local_item_status, sr.local_status, sr.local_agency from patron_request pr, supplier_request sr where sr.patron_request_id = pr.id order by date_created;