<div dir="ltr">If I may ask, what base report are you working from to modify?</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 26, 2022 at 12:32 PM Jessica Woolford via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org">evergreen-reports@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 dir="ltr"><div dir="auto">Hi Tiffany,<div dir="auto"><br></div><div>I was about to suggest using a transform of "substring" with an operator of "not in list," but in testing it I came across this bug: <br></div><div><br></div><div><a href="https://bugs.launchpad.net/evergreen/+bug/1834541" target="_blank">https://bugs.launchpad.net/evergreen/+bug/1834541</a></div><div><br></div><div>Another thing you could try is the "not between" operator. We have a template that filters this way by call number, so library staff can find call numbers that fall outside of a specific range. It was built in XUL but still works (in 3.6 anyway). You'd have to run two separate reports (not between ocm and oco, and then not between on and oo) to catch what you're looking for, but I think it could work.</div><div><br></div><div>Good luck!</div><div>Jessica<br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 26, 2022, 8:30 AM Tiffany Little via Evergreen-reports <<a href="mailto:evergreen-reports@list.evergreen-ils.org" target="_blank">evergreen-reports@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 dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Good morning all,</div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Does anyone have a creative way to create a filter of "does not contain" with multiple values?</div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Basically I'm trying to find bib records where the tcn_value does not contain ocm,ocn,on for OCLC records. I'm looking for our Acq records (roughly anything that doesn't have an OCLC prefix) that do have a bib source of "oclc". I can't do a "does contain %" because acq prefixes vary so wildly, and sometimes really bad ones don't have a prefix at all.</div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Does anyone have any ideas how I can accomplish this in the reporter? I haven't had much luck so far.</div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Tiffany</div><div><div dir="ltr"><div dir="ltr"><span><br><div dir="ltr" style="margin-left:0pt" align="left"><table style="border:medium none;border-collapse:collapse"><colgroup><col width="89"><col width="414"></colgroup><tbody><tr style="height:123pt"><td style="vertical-align:top;padding:5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:medium none;display:inline-block;overflow:hidden;width:75px;height:75px"><img src="https://lh6.googleusercontent.com/8c2XlzLbIIC6nDoa4yqQ8MzA0npF4WXpUnhhoK_uTqralZtjqVXRwPgmRep3jGYP6q41Sb0ULXqxX-QppYTC8cQyIfBAdqzLBgqvcQwVczkqqiunlj0KIbvy-R3bp-E0mlhF0A4v" style="margin-left: 0px; margin-top: 0px;" width="75" height="75"></span></span></p></td><td style="vertical-align:top;padding:5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="color:rgb(30,67,155);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">Tiffany Little, PINES Services Specialist: Acquisitions</font></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"></p><hr><p></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">Georgia Public Library Service | University System of Georgia</font></span></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341</font></span></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">(404) 235-7161 | <a href="mailto:tlittle@georgialibraries.org" rel="noreferrer" target="_blank">tlittle@georgialibraries.org</a></font></span></p><br><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:medium none;display:inline-block;overflow:hidden;width:36px;height:36px"><img src="https://lh6.googleusercontent.com/ql1so1R8csbb2W7DW5vjWe3mTAcApuM7a5CMXbsYnhmF1bDmG62LM_C1BOOyWdkb2PZGKGlaYRIceHjsSvsWPXNw6HPCKqtFLMKCJiPVU0RXu2dAey13WZ02Q6E6FmzNDJ_d9iBf" style="margin-left: 0px; margin-top: 0px;" width="36" height="36"></span></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:medium none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh3.googleusercontent.com/2qSr0-AREIyPSTC1gMsjyXLaBT-yQ7kS6iKvd1L9XrCXxhJDWCRo5eXBHCi7f35AZASOOyiH2Si-wtuXNR8YaA2j-17GWBmmo1mpGxXa7m-JwF4AzUD_5tZZE9n1NVilAJcnGtQs" style="margin-left: 0px; margin-top: 0px;" width="35" height="35"></span></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:medium none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh6.googleusercontent.com/-jM_GEWd7EZGo5MFiR1koKEkiupb_lmwNEMpNiQE3U6k1C2FkyuiNjtGKlWWGfX8zbZ1135yhOHnJSINmMTXgEQuu2RlHIg5hDKxaJ9cmh3Nr6el_vN4ZHlXcAmoCPPWduwXi26m" style="margin-left: 0px; margin-top: 0px;" width="35" height="35"></span></span></p></td></tr><tr style="height:21pt"><td colspan="2" style="vertical-align:top;padding:5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;text-align:center;margin-top:0pt;margin-bottom:0pt"><a href="http://georgialibraries.org/" rel="noreferrer" target="_blank"><span style="font-size:8pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span style="font-size:8pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:8pt;font-family:Verdana;color:rgb(67,67,67);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">for stories of Georgia libraries making an impact in our communities.</span></p></td></tr></tbody></table></div></span></div></div></div></div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" rel="noreferrer" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</blockquote></div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px">Tony Miller</div><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px"><span style="color:rgb(0,0,0);font-family:Calibri;font-size:small;background-color:rgb(255,255,255)"><b>User Services Coordinator </b></span><br></div><div style="border:0px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;line-height:24px"><div style="color:rgb(38,38,38);font-family:"Carrois Gothic",sans-serif;font-size:12.8px;border:0px;margin:0px;outline:0px;padding:0px;vertical-align:baseline"><div style="border:0px;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline"><div style="font-family:"Open Sans",sans-serif;font-size:18px;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(68,67,64)"><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><img src="https://pbmldstaff.files.wordpress.com/2022/03/01.png" alt="01" width="182" height="118" style="height: auto; max-width: 100%;"></div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">318 North Main Street | Poplar Bluff, MO 63901<br>(573) 686 – 8639</div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-weight:700"><a href="https://poplarbluff.org/" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Website</a> | <a href="https://poplarbluff.org/OTS.pdf" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Newsletter</a> | <a href="https://poplarbluff.org/annualreport.html" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Annual Report</a> | </span><span style="font-weight:700"><a href="http://poplarbluff.org/downloads.html" rel="noopener" style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px;color:rgb(21,182,184)" target="_blank">Digital Library</a></span><span style="font-weight:700"> </span></div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"> </div><div style="margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><p style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px 0px 1.6em;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-weight:700"><i><span style="font-family:garamond,"times new roman",serif;font-size:large;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><span style="font-family:inherit;font-size:18px;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">​</span></span></i></span><i style="font-size:revert;color:initial">​<span style="font-family:inherit;font-weight:700;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">Promoting Libraries to Make Our Communities Stronger</span></i></p><div style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px"><div style="font-family:inherit;font-weight:inherit;font-style:inherit;margin:0px;padding:0px;vertical-align:baseline;border:0px;outline:0px">Poplar Bluff Municipal Library District with its community partners provides and promotes equal access to reading, information, cultural and intellectual resources.</div></div></div></div></div></div></div><div style="border:0px;font-family:"Carrois Gothic",sans-serif;font-size:12.8px;margin:0px;outline:0px;padding:0px;vertical-align:baseline;color:rgb(38,38,38);line-height:24px"></div></div></div></div></div></div></div>