- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
We activated the "Allow On-shelf Holds" option in SYSADMIN > OPAC Configuration > Miscellaneous. How do we obtain the "pull list" in order to get the items off the shelf?
You will need to create a Prepackaged Access Reports custom report to generate the information for the "pull list". We recommend consulting the Voyager Customer Listserv for assistance in creating that custom query.
Items with an ITEM_STATUS.ITEM_STATUS of "1" and "HOLD_RECALL_ITEMS.HOLD_RECALL_STATUS of "1" will provide items that have a hold/recall status of "active" and item status of "not charged".
The following example pull list query, which can be run using Prepackaged Access Reports, was contributed by a helpful customer and is provided as-is:
SELECT MFHD_MASTER.DISPLAY_CALL_NO, ITEM_BARCODE.ITEM_BARCODE, BIB_TEXT.TITLE_BRIEF, [FIRST_NAME] & " " & [Last_Name] AS FullName, LOCATION.LOCATION_NAME, HOLD_RECALL.CREATE_DATE
FROM (((((((((ITEM_STATUS INNER JOIN ITEM ON ITEM_STATUS.ITEM_ID = ITEM.ITEM_ID) INNER JOIN MFHD_ITEM ON ITEM.ITEM_ID = MFHD_ITEM.ITEM_ID) INNER JOIN MFHD_MASTER ON MFHD_ITEM.MFHD_ID = MFHD_MASTER.MFHD_ID) INNER JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID) INNER JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID) INNER JOIN HOLD_RECALL_ITEMS ON ITEM.ITEM_ID = HOLD_RECALL_ITEMS.ITEM_ID) INNER JOIN BIB_ITEM ON ITEM.ITEM_ID = BIB_ITEM.ITEM_ID) INNER JOIN BIB_TEXT ON BIB_ITEM.BIB_ID = BIB_TEXT.BIB_ID) INNER JOIN HOLD_RECALL ON (HOLD_RECALL_ITEMS.HOLD_RECALL_ID = HOLD_RECALL.HOLD_RECALL_ID) AND (BIB_TEXT.BIB_ID = HOLD_RECALL.BIB_ID)) INNER JOIN PATRON ON HOLD_RECALL.PATRON_ID = PATRON.PATRON_ID
WHERE (((ITEM_STATUS.ITEM_STATUS)="1") AND ((HOLD_RECALL_ITEMS.HOLD_RECALL_STATUS)="1"))
ORDER BY MFHD_MASTER.DISPLAY_CALL_NO, LOCATION.LOCATION_NAME;
Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes. Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.
- Article last edited: 15-Apr-2020