<div dir="ltr">Hi Elizabeth, <div><br></div><div>I have a basic postgresql query for hold settings, this example looks specifically at opac.hold_notify:</div><div><br></div><div>SELECT card.barcode as user_barcode, <a href="http://aus.name">aus.name</a> as notify_setting, aus.value as notify_value<br> FROM actor.usr_setting aus<br> join actor.usr au on aus.usr = <a href="http://au.id">au.id</a><br> join actor.org_unit aou on au.home_ou = <a href="http://aou.id">aou.id</a><br> join actor.card card on au.card = <a href="http://card.id">card.id</a><br> where au.deleted = 'false'<br> and aou.shortname = 'LIB'<br> AND <a href="http://aus.name">aus.name</a> IN ('opac.hold_notify')<br></div><div><br></div><div>which returns values like this: </div><div>"opac.hold_notify" """phone:email"""<br>"opac.hold_notify" """phone:email"""<br>"opac.hold_notify" """email:sms"""<br>"opac.hold_notify" """phone:email"""<br>"opac.hold_notify" """email:sms"""<br>"opac.hold_notify" """phone:email"""<br>"opac.hold_notify" """phone:email:sms"""<br>"opac.hold_notify" """email"""<br></div><div><br></div><div>User Settings is a reporter source so I suspect this would be easy to duplicate but I haven't done it. </div><div><br></div><div>Lindsay</div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><b>Lindsay Stratton</b><div><b>Systems Librarian</b></div><div>Westchester Library System</div><div>570 Taxter Rd., 4th Floor</div><div>Elmsford, NY 10523</div><div><a href="mailto:lstratton@wlsmail.org" target="_blank">lstratton@wlsmail.org</a></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Jan 20, 2023 at 1:31 PM Elizabeth Davis via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org">evergreen-reports@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-4426512569057054408">
<div lang="EN-US" style="overflow-wrap: break-word;">
<div class="m_-4426512569057054408WordSection1">
<p class="MsoNormal">Hello<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I was curious if anyone has ever run a report on the User Settings for Hold Notices. We have a library interested in knowing how many people use email vs phone vs SMS. This seemed like the easiest way to count this, but I’m also open
to any other suggestions. <img width="991" height="315" style="width: 10.3229in; height: 3.2812in;" id="m_-4426512569057054408Picture_x0020_1" src="cid:185d08a6e474cff311"><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks, <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="vertical-align:baseline"><u></u><img width="83" height="83" style="width: 0.8645in; height: 0.8645in;" src="cid:185d08a6e47692e332" align="left" hspace="12"><u></u><b><span style="color:rgb(22,105,122)">Elizabeth
Davis</span></b><b> </b>(she/her), <b><i><span style="color:rgb(22,105,122)">Support & Project Management Specialist</span></i></b><span style="font-size:12pt;color:rgb(22,105,122)"> </span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><b><span style="font-size:12pt;color:rgb(51,102,204)">Pennsylvania Integrated Library System
</span></b><b><span style="color:rgb(68,114,196)">(PaILS) | SPARK</span></b><span style="font-size:12pt;color:rgb(51,102,204)"> </span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="color:rgb(51,102,204)">(717) 256-1627</span> |
<a href="mailto:katherine.dannehl@sparkpa.org" target="_blank"><span style="color:rgb(5,99,193)">elizabeth.davis@sparkpa.org</span></a> <br>
<a href="https://support.sparkpa.org/" target="_blank"><span style="color:rgb(5,99,193)">support.sparkpa.org</span></a><span style="color:rgb(51,102,204)"> |
</span><a href="mailto:support@sparkpa.org" target="_blank"><span style="color:rgb(5,99,193)">support@sparkpa.org</span></a><span style="color:rgb(51,102,204)"> </span><span style="font-size:9pt;font-family:"Segoe UI",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</div></blockquote></div>