[Evergreen-reports] Filter with multiple criteria?

[Tiffany Little]

Hi Tony,

I'm creating a report from scratch, but I'm using the Bibliographic Record
source.

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.


On Thu, May 26, 2022 at 2:05 PM Tony Miller via Evergreen-reports <
evergreen-reports at list.evergreen-ils.org> wrote:

> 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.
> _______________________________________________
> Evergreen-reports mailing list
> Evergreen-reports at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20220526/8ebf8599/attachment.htm>