[Evergreen-reports] Report Listing Barred Patrons with NO Lost Items

[Elizabeth Davis]

Sorry, the flag set to true.

Elizabeth Davis, MLIS
Pronouns: she/her
Head of Digital Services
Scranton Public Library
500 Vine Street
Scranton, PA 18510
Work-570-795-4332
Cell- 570-500-5962


From: Evergreen-reports <evergreen-reports-bounces at list.evergreen-ils.org> On Behalf Of Elizabeth Davis via Evergreen-reports
Sent: Wednesday, December 1, 2021 11:53 AM
To: Jessica Woolford <jwoolford at biblio.org>; Evergreen Community Reports Email List <evergreen-reports at list.evergreen-ils.org>
Subject: Re: [Evergreen-reports] Report Listing Barred Patrons with NO Lost Items

Hi Jennifer

Can you use the Open Billable Transaction Summary Source and filter on barred flag value set to false and copy status with the not in list operator?

Elizabeth Davis, MLIS
Pronouns: she/her
Head of Digital Services
Scranton Public Library
500 Vine Street
Scranton, PA 18510
Work-570-795-4332
Cell- 570-500-5962


From: Evergreen-reports <evergreen-reports-bounces at list.evergreen-ils.org<mailto:evergreen-reports-bounces at list.evergreen-ils.org>> On Behalf Of Jessica Woolford via Evergreen-reports
Sent: Wednesday, December 1, 2021 10:23 AM
To: Evergreen Community Reports Email List <evergreen-reports at list.evergreen-ils.org<mailto:evergreen-reports at list.evergreen-ils.org>>
Subject: [Evergreen-reports] Report Listing Barred Patrons with NO Lost Items

Hi all,

A library is requesting a report listing patrons with the barred flag that don't currently have lost items checked out to them. I can think of several ways to create a report template showing patrons WITH lost items, but I'm at a loss for using the reporter to get patrons WITHOUT them. For now, we've written a SQL query that lists patrons meeting this criteria, but they would like to be able to run this report ad hoc. If you've been able to create something similar, please let me know!

Thanks,
Jessica

--
Jessica Woolford
Evergreen Systems Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
203-577-4070 ext. 105
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20211201/e8280d77/attachment-0001.html>