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
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,
>
> 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
I know our does not but as you said the admin might be willing to run it
for us!
*Jennifer Bruch*
Bethlehem Area Public Library
11 W. Church Street
Bethlehem, PA 18018
610-867-3761 x232
On Wed, Oct 10, 2018 at 3:57 PM, Jessica Woolford
wrote:
> You're welcome! I should mention that some
You're welcome! I should mention that some consortia don't allow users
direct access to the database for security purposes (we don't). If that's
the case, perhaps your sys admin would be willing to run the occasional
query for you. It doesn't hurt to ask!
On Wed, Oct 10, 2018 at 3:53 PM Jennifer
Thanks
*Jennifer Bruch*
Bethlehem Area Public Library
11 W. Church Street
Bethlehem, PA 18018
610-867-3761 x232
On Wed, Oct 10, 2018 at 3:47 PM, Jessica Woolford
wrote:
> Hi Jennifer,
>
> First, check with your system administrator to make sure you have access
> to your Evergreen database,
Hi Jennifer,
First, check with your system administrator to make sure you have access to
your Evergreen database, either through psql (command line) or a GUI
(PGAdmin).
Then, I would recommend watching Rogan Hamby's excellent presentation from
the 2014 Evergreen conference - SQL for Librarians:
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
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,
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
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
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
11 matches
Mail list logo
