[Evergreen-reports] Hold Notices Check Boxes Report

[Elizabeth Davis]

HI Lindsay

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.

I’d be happy to share screen with anyone who is interested in the reporter side.


[cid:image005.png at 01D92CDE.25B76C80]Elizabeth Davis (she/her), Support & Project Management Specialist
Pennsylvania Integrated Library System (PaILS) | SPARK
(717) 256-1627 | elizabeth.davis at sparkpa.org<mailto:katherine.dannehl at sparkpa.org>
support.sparkpa.org<https://support.sparkpa.org/> | support at sparkpa.org<mailto:support at sparkpa.org>

From: Lindsay Stratton <lstratton at wlsmail.org>
Sent: Friday, January 20, 2023 2:03 PM
To: Evergreen Community Reports Email List <evergreen-reports at list.evergreen-ils.org>
Cc: Elizabeth Davis <elizabeth.davis at sparkpa.org>
Subject: Re: [Evergreen-reports] Hold Notices Check Boxes Report

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<http://aus.name> as notify_setting, aus.value as notify_value
FROM actor.usr_setting aus
join actor.usr au on aus.usr = au.id<http://au.id>
join actor.org_unit aou on au.home_ou = aou.id<http://aou.id>
join actor.card card on au.card = card.id<http://card.id>
where au.deleted = 'false'
and aou.shortname = 'LIB'
AND aus.name<http://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<mailto: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<mailto: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.  [cid:image003.png at 01D92CDE.25B3EA10]


Thanks,

[cid:image004.png at 01D92CDE.25B3EA10]Elizabeth Davis (she/her), Support & Project Management Specialist
Pennsylvania Integrated Library System (PaILS) | SPARK
(717) 256-1627 | elizabeth.davis at sparkpa.org<mailto:katherine.dannehl at sparkpa.org>
support.sparkpa.org<https://support.sparkpa.org/> | support at sparkpa.org<mailto:support at sparkpa.org>

_______________________________________________
Evergreen-reports mailing list
Evergreen-reports at list.evergreen-ils.org<mailto: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/ea8c5f2b/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10034 bytes
Desc: image001.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230120/ea8c5f2b/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 19110 bytes
Desc: image003.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230120/ea8c5f2b/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 5399 bytes
Desc: image004.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230120/ea8c5f2b/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 5407 bytes
Desc: image005.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230120/ea8c5f2b/attachment-0007.png>