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

2018-10-11 Thread Chris Sharp
> > 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. > If this is

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

2018-10-11 Thread Morgan, Michele
I think a holds reporter source would be useful to many Evergreen users. Also, a suggestion for Jessica's query - adding left joins will pick up holds that don't appear in the hold_copy_map: SELECT DISTINCT ON (ahr.id) ahr.request_time, acard.barcode, au.family_name, au.first_given_name,

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

2018-10-11 Thread Jessica Woolford
Thanks, Michele! Chris, good idea. I'll file a bug ticket. I'll probably file another one for a source that includes a way to show the format of the record that the hold is on in a more meaningful way. I get that request a lot, and I have just been throwing Item Form in there and having the