Holds In Cataloguing

Polaris
1

I’m sure I figured this out a couple of weeks ago in Simply Reports, but I didn’t save it and now I can’t figure it out again. How do I get a list of items in cataloguing that have bib or item specific holds on them? Thanks!

2

I took a look in Simply Reports and I couldn’t find a way to do it either…it sounds like you want a “list” report, but item and bib list reports won’t tell you if the item fills a hold, and the holds list report won’t tell you if the item is in cataloging (which I’m interpreting as the item status being in processing or similar). At least as far as I’m aware!

This might get you what you’re looking for:

select callnumber,barcode,browsetitle,assignedbranchid from circitemrecords with (nolock)
left join bibliographicrecords with (nolock) on circitemrecords.associatedbibrecordid=bibliographicrecords.bibliographicrecordid
left join itemrecorddetails with (nolock) on circitemrecords.itemrecordid=itemrecorddetails.itemrecordid
where itemstatusid=15 -- "in processing" but could be a different status in your system
	and associatedbibrecordid in 
	(select bibliographicrecordid from sysholdrequests with (nolock) 
	where sysholdstatusid =3) -- you probably don't want to count instances where holds are held/cancelled/expired as "bibs that have holds on them"

If you also want info about how many holds are currently active for that title, whether they are item-specific or bib-level, or pickup library, you’d probably want to join the sysholdrequests table in again, either on its own or in a subquery.

If you want to use the query in the find tool, maybe something like this:

select itemrecordid from circitemrecords with (nolock)
where itemstatusid=15 
	and associatedbibrecordid in 
	(select bibliographicrecordid from sysholdrequests with (nolock) 
	where sysholdstatusid =3)
1 Like
3

Thanks @ebrondermajor. That’s exactly what I was looking for. And I remembered where I had found something sort of what I was looking for before. It wasn’t in Simply Reports so no wonder neither of us could find it there now/again. It was a query our trainer gave me. But he hadn’t limited it to hold status = 3 so it was bringing in the held, cancelled holds, etc. which I definitely didn’t need. Your query is perfect and I have now saved it. Thanks again!

1 Like