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 <jwoolf...@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 <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. >>> <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 >