IUG FORUM

Stay always connected!
  1. Andrea Taylor
  2. Sierra/ Millennium/ Encore
  3. Tuesday, 27 December 2016
  4.  Subscribe via email
How can I create list or use an SQL to retrieve patrons that should have been notified by teleforms between two dates?
Comment
There are no comments made yet.
Accepted Answer
Accepted Answer Pending Moderation
0
Votes
Undo
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
Comment
  1. Andrea Taylor
  2. 3 years ago
  3. #587
Thanks Karen. I just realized I should have said "should have received hold ready for pick up notification".

I tried
PATRON Notice preference = p
AND
ITEM status = !

I would have thought it was simple...but it didn't work.
There are no comments made yet.
Accepted Answer Pending Moderation
0
Votes
Undo
Hi Andrea,
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.

SELECT
h.id AS "Hold ID",
h.patron_record_id AS "Patron rec #",
p.record_type_code || p.record_num AS "Patron #",
h.pickup_location_code,
v.record_type_code || v.record_num AS "Item #",
m.record_last_updated_gmt,
p.barcode AS "patron barcode",
v.barcode AS "item barcode"

FROM
sierra_view.hold h

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

WHERE
h.status = 'i' AND
m.record_last_updated_gmt BETWEEN ('2016-12-14') AND ('2016-12-16')

ORDER BY h.pickup_location_code;
Comment
There are no comments made yet.
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!