<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1028" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">HI Lindsay<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks! I was able to replicate in the reporter with this. Do you happen to know the different between the "phone:sms" and "phone|sms"? I spot checked and didn’t see anything different in the accounts.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’d be happy to share screen with anyone who is interested in the reporter side.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="vertical-align:baseline"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="Picture_x0020_1" o:spid="_x0000_s1027" type="#_x0000_t75" style='position:absolute;margin-left:0;margin-top:.15pt;width:62.25pt;height:62.25pt;z-index:251660288;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page'>
<v:imagedata src="cid:image001.png@01D92CDE.25B3EA10" o:title="" />
<w:wrap type="square"/>
</v:shape><![endif]--><![if !vml]><img width="83" height="83" style="width:.8645in;height:.8645in" src="cid:image005.png@01D92CDE.25B76C80" align="left" hspace="12" v:shapes="Picture_x0020_1"><![endif]><b><span style="color:#16697A">Elizabeth
Davis</span></b><b> </b>(she/her), <b><i><span style="color:#16697A">Support & Project Management Specialist</span></i></b><span style="font-size:12.0pt;color:#16697A"> </span><span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><b><span style="font-size:12.0pt;color:#3366CC">Pennsylvania Integrated Library System
</span></b><b><span style="color:#4472C4">(PaILS) | SPARK</span></b><span style="font-size:12.0pt;color:#3366CC"> </span><span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="color:#3366CC">(717) 256-1627</span> |
<a href="mailto:katherine.dannehl@sparkpa.org" target="_blank"><span style="color:#0563C1">elizabeth.davis@sparkpa.org</span></a> <br>
<a href="https://support.sparkpa.org/" target="_blank"><span style="color:#0563C1">support.sparkpa.org</span></a><span style="color:#3366CC"> |
</span><a href="mailto:support@sparkpa.org" target="_blank"><span style="color:#0563C1">support@sparkpa.org</span></a><span style="color:#3366CC"> </span><span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Lindsay Stratton <lstratton@wlsmail.org> <br>
<b>Sent:</b> Friday, January 20, 2023 2:03 PM<br>
<b>To:</b> Evergreen Community Reports Email List <evergreen-reports@list.evergreen-ils.org><br>
<b>Cc:</b> Elizabeth Davis <elizabeth.davis@sparkpa.org><br>
<b>Subject:</b> Re: [Evergreen-reports] Hold Notices Check Boxes Report<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Elizabeth, <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I have a basic postgresql query for hold settings, this example looks specifically at opac.hold_notify:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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')<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">which returns values like this: <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">"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"""<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">User Settings is a reporter source so I suspect this would be easy to duplicate but I haven't done it. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Lindsay<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b>Lindsay Stratton</b><o:p></o:p></p>
<div>
<p class="MsoNormal"><b>Systems Librarian</b><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Westchester Library System<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">570 Taxter Rd., 4th Floor<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Elmsford, NY 10523<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="mailto:lstratton@wlsmail.org" target="_blank">lstratton@wlsmail.org</a><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">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:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hello<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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 border="0" width="991" height="315" style="width:10.3229in;height:3.2812in" id="m_-4426512569057054408Picture_x0020_1" src="cid:image003.png@01D92CDE.25B3EA10"><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thanks,
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;vertical-align:baseline">
<!--[if gte vml 1]><v:shape id="Picture_x0020_2" o:spid="_x0000_s1026" type="#_x0000_t75" style='position:absolute;margin-left:0;margin-top:0;width:62.25pt;height:62.25pt;z-index:251658240;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:left;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:line;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page' o:allowoverlap="f">
<v:imagedata src="cid:image004.png@01D92CDE.25B3EA10" o:title="" />
<w:wrap type="square" anchory="line"/>
</v:shape><![endif]--><![if !vml]><img width="83" height="83" style="width:.8645in;height:.8645in" src="cid:image004.png@01D92CDE.25B3EA10" align="left" hspace="12" v:shapes="Picture_x0020_2"><![endif]><b><span style="color:#16697A">Elizabeth
Davis</span> </b>(she/her), <b><i><span style="color:#16697A">Support & Project Management Specialist</span></i></b><span style="font-size:12.0pt;color:#16697A"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;vertical-align:baseline">
<b><span style="font-size:12.0pt;color:#3366CC">Pennsylvania Integrated Library System
</span><span style="color:#4472C4">(PaILS) | SPARK</span></b><span style="font-size:12.0pt;color:#3366CC"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;vertical-align:baseline">
<span style="color:#3366CC">(717) 256-1627</span> | <a href="mailto:katherine.dannehl@sparkpa.org" target="_blank">
<span style="color:#0563C1">elizabeth.davis@sparkpa.org</span></a> <br>
<a href="https://support.sparkpa.org/" target="_blank"><span style="color:#0563C1">support.sparkpa.org</span></a><span style="color:#3366CC"> |
</span><a href="mailto:support@sparkpa.org" target="_blank"><span style="color:#0563C1">support@sparkpa.org</span></a><span style="color:#3366CC"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<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" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><o:p></o:p></p>
</div>
</blockquote>
</div>
</div>
</body>
</html>