Hello, I was just wondering if anyone had any scripts for counting holds and checkouts in the same sql script. at the end of the year, I’ve been asked to compile a top list based on holds and checkouts. I know i can get YTD Circs from the circitemrecords table, but how do i connect that to holds?
Although you’ll have to manually “add up” things, it may still be easiest to run this as two separate simplyreports reports. That way you’ll be able to apply the filters that will eventually be requested when folks find the most popular titles are the Dog Man book series.
