<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)">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
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="1026" />
</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="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Jennifer<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Elizabeth Davis, MLIS<o:p></o:p></p>
<p class="MsoNormal">Pronouns: she/her<o:p></o:p></p>
<p class="MsoNormal">Head of Digital Services <o:p></o:p></p>
<p class="MsoNormal">Scranton Public Library<o:p></o:p></p>
<p class="MsoNormal">500 Vine Street<o:p></o:p></p>
<p class="MsoNormal">Scranton, PA 18510<o:p></o:p></p>
<p class="MsoNormal">Work-570-795-4332<o:p></o:p></p>
<p class="MsoNormal">Cell- 570-500-5962<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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> Evergreen-reports <evergreen-reports-bounces@list.evergreen-ils.org>
<b>On Behalf Of </b>Jessica Woolford via Evergreen-reports<br>
<b>Sent:</b> Wednesday, December 1, 2021 10:23 AM<br>
<b>To:</b> Evergreen Community Reports Email List <evergreen-reports@list.evergreen-ils.org><br>
<b>Subject:</b> [Evergreen-reports] Report Listing Barred Patrons with NO Lost Items<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hi all,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">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!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Jessica<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><br>
-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Jessica Woolford<o:p></o:p></p>
<div>
<p class="MsoNormal">Evergreen Systems Manager<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Bibliomation, Inc.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">24 Wooster Ave.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Waterbury, CT 06708<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">203-577-4070 ext. 105<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>