"not picked up" report
Hi,
I'm trying to write a query that would tell me if an item has been placed on hold but never checked out. I can run a report for everything that's been placed on hold in a given time (tracking.changedto = 13) or checked out (changedto = 11 ), but am not sure how to combine them. Any ideas?
Thank you,
Moira
-
AdminKatie Gillespie (Special Collections & Archives Program Manager, Atlas Systems, Inc.) commented
Hi Moira,
I'm going to email you with a suggested query.
Thanks,
Katie -
Moira Fitzgerald commented
Thanks, Katie. I'm afraid we haven't implemented Atlas BI yet, since we're self-hosted there were a few extra steps for us, and the project is still in our IT queue. But it's good to know that the report is there. In the meantime, if you had any SQL code that could do the trick, please let me know.
-
AdminKatie Gillespie (Special Collections & Archives Program Manager, Atlas Systems, Inc.) commented
Hi Moira,
Sorry for the delayed reply. We added a report for this in the new Atlas BI reports. Do you have access to that? Does it give you the data you were looking for?