Try this Create List:
PATRON Notice Preference equal to "p" AND ITEM ODUE DATE between "12-23-2016"and "12-27-2016" AND ITEM # OVERDUE greater than or equal to "1"
--Karen Perone, Rodman Public Library
We had two print notices that failed to make it to the printer 2 weeks ago and one of them was our hold pick up notices.
If you are hosted, you can request a list of p#s from the flat file on the server (although it took Innovative 6 days to get us the list). We have created an SQL which matched the list sent to us by Innovative in case it ever happens again (we hope not).
Feel free to modify the output or change dates to suite.
h.id AS "Hold ID",
h.patron_record_id AS "Patron rec #",
p.record_type_code || p.record_num AS "Patron #",
v.record_type_code || v.record_num AS "Item #",
p.barcode AS "patron barcode",
v.barcode AS "item barcode"
JOIN sierra_view.item_view v ON v.id = h.record_id
JOIN sierra_view.record_metadata m ON m.id = v.id
JOIN sierra_view.patron_view p ON p.id = h.patron_record_id
h.status = 'i' AND
m.record_last_updated_gmt BETWEEN ('2016-12-14') AND ('2016-12-16')