<div dir="ltr"><div>Hi Samantha,</div><div><br></div><div>Below are display fields and filters for a Claims Returned/Claims Never Checked Out report we are using. If I were to build it from scratch, I would leave out or limit the patron info.  It doesn't have "Is Deleted" as a filter, but it does have it in the display fields and I don't see why it wouldn't work in the filters if needed. Hopefully this will give you a place to start. Let me know if you have any questions!</div><div><br></div><div>Jessica</div><div><br></div><div>Filters:<br></div><div><img src="cid:ii_li3d6frv0" alt="image.png" style="margin-right: 25px;"><br><br></div><div>Display Fields:</div><div><br></div><div><img src="cid:ii_li3d7rdz1" alt="image.png" style="margin-right: 25px;"><br><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 25, 2023 at 12:30 PM O'Connor, Samantha via Evergreen-general <<a href="mailto:evergreen-general@list.evergreen-ils.org">evergreen-general@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg2390602625005352700">




<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I'm wondering if anyone can help me with something. I am trying to create a report of non-deleted items that have a current claims returned. The templates I have worked with so far are all failing when I try to add the deleted=f filter. Additionally, when I
 put together queries in the database looking for this information, I get items that were claimed returned at some point in the past but have since been located and checked out by others. I'm filtering both the queries and reports using fine stop reason is
 claims returned. Is there another way that items that have been claimed returned might show up in the database? Or any suggestions on how to filter my results to only the materials that are currently still checked out to the people who claim to have returned
 them?</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Any help or suggestions would be welcome. Thanks in advance!</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div id="m_-4420310483908198439Signature">
<div>
<div><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<p style="margin:0in;text-align:start;font-size:11pt;font-family:Calibri,sans-serif;color:rgb(36,36,36);background-color:rgb(255,255,255)">
<b><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black">Samantha O’Connor</span></b></p>
<p style="margin:0in;text-align:start;font-size:11pt;font-family:Calibri,sans-serif;color:rgb(36,36,36);background-color:rgb(255,255,255)">
<span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black">NC Cardinal Training Specialist</span></p>
<p style="margin:0in;text-align:start;font-size:11pt;font-family:Calibri,sans-serif;color:rgb(36,36,36);background-color:rgb(255,255,255)">
<span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black">NC Dept. of Natural and Cultural Resources</span></p>
<p style="margin:0in;text-align:start;font-size:11pt;font-family:Calibri,sans-serif;color:rgb(36,36,36);background-color:rgb(255,255,255)">
<u><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:rgb(5,99,193)"><a href="mailto:samantha.oconnor@ncdcr.gov" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="margin:0px;color:blue">samantha.oconnor@ncdcr.gov</span></a><span style="margin:0px"> </span></span></u><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black"> </span><span style="font-size:10pt;margin:0px;color:black"></span></p>
<p style="margin:0in;text-align:start;font-size:11pt;font-family:Calibri,sans-serif;color:rgb(36,36,36);background-color:rgb(255,255,255)">
<span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black"><a href="https://statelibrary.ncdcr.gov/ld/nc-cardinal" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="margin:0px;color:rgb(5,99,193)">https://statelibrary.ncdcr.gov/ld/nc-cardinal</span></a></span></p>
<p style="margin:0in;text-align:start;font-size:11pt;font-family:Calibri,sans-serif;color:rgb(36,36,36);background-color:rgb(255,255,255)">
<span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black"><br>
109 East Jones Street | 4640 Mail Service Center </span><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"><br>
<span style="margin:0px;color:black">Raleigh, North Carolina 27699-4600</span></span></p>
<p style="margin:6pt 0in 0in;text-align:start;font-size:11pt;font-family:Calibri,sans-serif;color:rgb(36,36,36);background-color:rgb(255,255,255)">
<a href="https://www.facebook.com/StateLibraryNC/" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">Facebook</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"> <span style="margin:0px"> </span></span><a href="https://twitter.com/StateLibraryNC" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">Twitter</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"><span style="margin:0px"> </span> </span><a href="http://www.instagram.com/ncculture" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">Instagram</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"> <span style="margin:0px"> </span></span><a href="https://www.youtube.com/user/statelibrarync/" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">YouTube</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"><span style="margin:0px"> </span> </span><a href="https://statelibrary.ncdcr.gov/" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">Website</span></a></p>
<br>
</span></div>
</div>
</div>
</div>
</div>

_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</div></blockquote></div><br clear="all"><br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Jessica Woolford<div>Evergreen Systems Manager<br></div><div>Bibliomation, Inc.</div><div>24 Wooster Ave.</div><div>Waterbury, CT 06708</div><div>203-577-4070 ext. 105</div></div></div></div></div></div></div></div></div>