<div dir="ltr"><div>Thanks, Michele!</div><div><br></div><div>Chris, good idea. I'll file a bug ticket. I'll probably file another one for a source that includes a way to show the format of the record that the hold is on in a more meaningful way. I get that request a lot, and I have just been throwing Item Form in there and having the libraries look up the codes. Some are OK with that, but some are dissatisfied. <br></div></div><br><div class="gmail_quote"><div dir="ltr">On Thu, Oct 11, 2018 at 9:37 AM Morgan, Michele <<a href="mailto:mmorgan@noblenet.org">mmorgan@noblenet.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr">I think a holds reporter source would be useful to many Evergreen users. </div><div dir="ltr"><br></div><div dir="ltr">Also, a suggestion for Jessica's query - adding left joins will pick up holds that don't appear in the hold_copy_map:<div><br></div><font face="monospace, monospace">SELECT DISTINCT ON (<a href="http://ahr.id" target="_blank">ahr.id</a>) ahr.request_time, acard.barcode, au.family_name, au.first_given_name, rmsr.title, rmsr.tcn_value<br>FROM action.hold_request ahr<br>JOIN actor.usr au ON ahr.usr = <a href="http://au.id" target="_blank">au.id</a><br>JOIN actor.card acard ON au.card = <a href="http://acard.id" target="_blank">acard.id</a><br>left JOIN action.hold_copy_map ahcm ON <a href="http://ahr.id" target="_blank">ahr.id</a> = ahcm.hold<br>left JOIN asset.copy ac ON ahcm.target_copy = <a href="http://ac.id" target="_blank">ac.id</a><br>left JOIN asset.call_number acn ON ac.call_number = <a href="http://acn.id" target="_blank">acn.id</a><br>left JOIN reporter.materialized_simple_record rmsr ON <a href="http://rmsr.id" target="_blank">rmsr.id</a> = acn.record<br>WHERE ahr.pickup_lib = *org_unit id*<br>AND ahr.capture_time IS NULL<br>AND ahr.cancel_time IS NULL<br>AND ahr.fulfillment_time IS NULL<br>AND ahr.frozen = FALSE<br>AND date(ahr.request_time) < '2018-09-01'<br>AND <a href="http://ahr.id" target="_blank">ahr.id</a> NOT IN (SELECT hold FROM action.hold_copy_map WHERE target_copy IN (SELECT id FROM asset.copy WHERE status = 9 AND circ_lib = *org_unit id*));</font><br><div><br></div><div>Hope this helps,</div><div>Michele</div><div><br clear="all"><div><div dir="ltr" class="m_-5104425766025575790gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>--</div><div>Michele M. Morgan, <span style="font-size:12.8px">Technical Support Analyst<br></span></div><div><span style="font-size:12.8px">North of Boston Library Exchange, Danvers Massachusetts</span></div><div><span style="font-size:12.8px"><a href="mailto:mmorgan@noblenet.org" target="_blank">mmorgan@noblenet.org</a></span></div><div><br></div></div></div></div></div></div></div></div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Thu, Oct 11, 2018 at 6:41 AM Chris Sharp <<a href="mailto:csharp@georgialibraries.org" target="_blank">csharp@georgialibraries.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><div>Thanks for your question. It made me go back and look at the generated SQL, and realize that what they are looking for is probably too complex for the reporter. I ended up writing my own SQL query to generate the report. I'm happy to share it if anyone is interested.<br></div><div></div></div></div></blockquote></div><br clear="all"><div>If this is something libraries want/need, that makes a case for creating a new reports source. I would suggest opening a wishlist bug report if you think that's the case. Perhaps we could take a stab at doing this at the Hack-A-Way next month?<br></div><div><br></div>-- <br><div dir="ltr" class="m_-5104425766025575790m_5714842349478491586gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div><div><div>Chris Sharp<br></div>PINES System Administrator<br></div>Georgia Public Library Service<br></div>1800 Century Place, Suite 580</div>Atlanta, Georgia 30345<br>(404) 235-7147<br></div></div></div></div></div>
</blockquote></div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Jessica Woolford<div>Evergreen Systems Manager<br></div><div>Bibliomation, Inc.</div><div>24 Wooster Ave.</div><div>Waterbury, CT 06708</div><div>203-577-4070 ext. 105</div></div></div></div></div></div></div></div></div>