[OPEN-ILS-GENERAL] Filtering acquisitions items out of a hold report

[Jennifer Bruch]

Hi Jessica,
My library cataloger is interested in having a report like this as well but
I have no experience using SQL on the backend of Evergreen. Can you tell me
how you go about learning this?

Thanks

*Jennifer Bruch*
Bethlehem Area Public Library
11 W. Church Street
Bethlehem, PA 18018
610-867-3761 x232

On Wed, Oct 10, 2018 at 2:26 PM, Jessica Woolford <jwoolford at biblio.org>
wrote:

> Hi Chris,
>
> Thanks for your question. It made me go back and look at the generated
> SQL, and realize that what they are looking for is probably too complex for
> the reporter. I ended up writing my own SQL query to generate the report.
> I'm happy to share it if anyone is interested.
>
> Thanks again!
> Jessica
>
>
>
> On Tue, Oct 2, 2018 at 6:28 AM Chris Sharp <csharp at georgialibraries.org>
> wrote:
>
>> Jessica,
>>
>> Can you provide the generated SQL from the attempts that aren't working?
>>
>> Thanks!
>>
>> Chris
>>
>> On Mon, Oct 1, 2018 at 2:30 PM Jessica Woolford <jwoolford at biblio.org>
>> wrote:
>>
>>> Hi all,
>>>
>>> We have a library who wants a report listing requests that have not been
>>> filled in over a month. That is no problem - we have several libraries
>>> using a report that can do this. However, they would also like to filter
>>> their acquisitions items out of the report. The only indication that an
>>> item is in acquisitions is on the copy level, so this has been challenging
>>> to achieve in the reporter.
>>>
>>> These are constant filters I have in the report:
>>>
>>> Hold Request > Request Date/Time (transform: Date, Operator: Before
>>> (Date/Time)
>>> Hold Request > Pickup Library (Operator: In List)
>>> Hold Request > Capture Date/Time (Operator: Is NULL)
>>> Hold Request > Hold Cancel Date/Time (Operator: Is NULL)
>>> Hold Request > Currently Frozen (Operator: Equals, Value: False)
>>>
>>> Here are the filters I have tried:
>>>
>>> Hold Request > Bib Record link > Target Bib Record > Call Number >
>>> Copies > Copy Status > id (Operator: In List, Value: On order (chosen by
>>> user))
>>> I still get holds on bibs that have copies with a status of On order.
>>>
>>> Hold Request > Bib Record link > Target Bib Record > Call Number >
>>> Copies > Active Date/Time (Operator Is NOT NULL)
>>> I still get holds on bibs that have copies with no Active Date.
>>>
>>> I have played a little bit with nullability selection on both fields,
>>> but I haven't had any success.
>>>
>>> Can anybody think of anything that I haven't considered?
>>>
>>> Thanks,
>>> Jessica
>>> --
>>> Jessica Woolford
>>> Evergreen Systems Manager
>>> Bibliomation, Inc.
>>> 24 Wooster Ave.
>>> <https://maps.google.com/?q=24+Wooster+Ave.+Waterbury,+CT+06708&entry=gmail&source=g>
>>> Waterbury, CT 06708
>>> <https://maps.google.com/?q=24+Wooster+Ave.+Waterbury,+CT+06708&entry=gmail&source=g>
>>> 203-577-4070 ext. 105
>>>
>>
>>
>> --
>> Chris Sharp
>> PINES System Administrator
>> Georgia Public Library Service
>> 1800 Century Place, Suite 580
>> <https://maps.google.com/?q=1800+Century+Place,+Suite+580+Atlanta,+Georgia+30345&entry=gmail&source=g>
>> Atlanta, Georgia 30345
>> <https://maps.google.com/?q=1800+Century+Place,+Suite+580+Atlanta,+Georgia+30345&entry=gmail&source=g>
>> (404) 235-7147
>>
>
>
> --
> Jessica Woolford
> Evergreen Systems Manager
> Bibliomation, Inc.
> 24 Wooster Ave.
> <https://maps.google.com/?q=24+Wooster+Ave.+Waterbury,+CT+06708&entry=gmail&source=g>
> Waterbury, CT 06708
> <https://maps.google.com/?q=24+Wooster+Ave.+Waterbury,+CT+06708&entry=gmail&source=g>
> 203-577-4070 ext. 105
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20181010/11eb8664/attachment.html>