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

[Chris Sharp]

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.
> Waterbury, CT 06708
> 203-577-4070 ext. 105
>


-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 580
Atlanta, Georgia 30345
(404) 235-7147
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20181002/8d16ee88/attachment.html>