[Evergreen-reports] Hold Notices Check Boxes Report

[Lindsay Stratton]

Hi Elizabeth,

I have a basic postgresql query for hold settings, this example looks
specifically at opac.hold_notify:

SELECT card.barcode as user_barcode, aus.name as notify_setting, aus.value
as notify_value
FROM actor.usr_setting aus
join actor.usr au on aus.usr = au.id
join actor.org_unit aou on au.home_ou = aou.id
join actor.card card on au.card = card.id
where au.deleted = 'false'
and aou.shortname = 'LIB'
AND aus.name IN ('opac.hold_notify')

which returns values like this:
"opac.hold_notify" """phone:email"""
"opac.hold_notify" """phone:email"""
"opac.hold_notify" """email:sms"""
"opac.hold_notify" """phone:email"""
"opac.hold_notify" """email:sms"""
"opac.hold_notify" """phone:email"""
"opac.hold_notify" """phone:email:sms"""
"opac.hold_notify" """email"""

User Settings is a reporter source so I suspect this would be easy to
duplicate but I haven't done it.

Lindsay

*Lindsay Stratton*
*Systems Librarian*
Westchester Library System
570 Taxter Rd., 4th Floor
Elmsford, NY 10523
lstratton at wlsmail.org


On Fri, Jan 20, 2023 at 1:31 PM Elizabeth Davis via Evergreen-reports <
evergreen-reports at list.evergreen-ils.org> wrote:

> Hello
>
>
>
> 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.
>
>
>
>
>
> Thanks,
>
>
>
> *Elizabeth Davis* (she/her), *Support & Project Management Specialist*
>
> *Pennsylvania Integrated Library System **(PaILS) | SPARK*
>
> (717) 256-1627 | elizabeth.davis at sparkpa.org
> <katherine.dannehl at sparkpa.org>
> support.sparkpa.org | support at sparkpa.org
>
>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230120/b3acaf44/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 19110 bytes
Desc: not available
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230120/b3acaf44/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 5399 bytes
Desc: not available
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230120/b3acaf44/attachment-0003.png>