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 <csh...@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 <jwoolf...@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 > -- Jessica Woolford Evergreen Systems Manager Bibliomation, Inc. 24 Wooster Ave. Waterbury, CT 06708 203-577-4070 ext. 105