[Evergreen-reports] Filter with multiple criteria?

[Tony Miller]

If I may ask, what base report are you working from to modify?

On Thu, May 26, 2022 at 12:32 PM Jessica Woolford via Evergreen-reports <
evergreen-reports at list.evergreen-ils.org> wrote:

> Hi Tiffany,
>
> 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:
>
> https://bugs.launchpad.net/evergreen/+bug/1834541
>
> 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.
>
> Good luck!
> Jessica
>
> On Thu, May 26, 2022, 8:30 AM Tiffany Little via Evergreen-reports <
> evergreen-reports at list.evergreen-ils.org> wrote:
>
>> Good morning all,
>>
>> Does anyone have a creative way to create a filter of "does not contain"
>> with multiple values?
>>
>> 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.
>>
>> Does anyone have any ideas how I can accomplish this in the reporter? I
>> haven't had much luck so far.
>>
>> Tiffany
>>
>> Tiffany Little, PINES Services Specialist: Acquisitions
>>
>> ------------------------------
>>
>> Georgia Public Library Service | University System of Georgia
>>
>> 2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341
>>
>> (404) 235-7161 | tlittle at georgialibraries.org
>>
>> Join our email list <http://georgialibraries.org/> for stories of
>> Georgia libraries making an impact in our communities.
>> _______________________________________________
>> Evergreen-reports mailing list
>> Evergreen-reports at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>>
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>


-- 
Tony Miller
*User Services Coordinator *
[image: 01]
318 North Main Street | Poplar Bluff, MO 63901
(573) 686 – 8639
Website <https://poplarbluff.org/> | Newsletter
<https://poplarbluff.org/OTS.pdf> | Annual Report
<https://poplarbluff.org/annualreport.html> | Digital Library
<http://poplarbluff.org/downloads.html>


*​**​Promoting Libraries to Make Our Communities Stronger*
Poplar Bluff Municipal Library District with its community partners
provides and promotes equal access to reading, information, cultural and
intellectual resources.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20220526/2ab918c7/attachment-0001.htm>