The Horizon ILS has a list of holds where the report is run but if the list is not kept it is lost and you have to run a sql script to recover the list. You will require sql studio, and a login to the database. Once logged in.
Select your ILS DATABASE using SQL Studio or change "$ILSDatabase" in the script below to be the name of your ILS Database and it will automatically select the database for you.
USE [$ILSDATABASE]
GO
update request set fill_date = NULL, fill_location = NULL,
fill_item# = NULL where
fill_date = datediff(dd,'01 jan 1970',getdate())and fill_location = '$location' and request_status = 0
Below is a sample of what the script looks like in SQL Studio.
In the script change $location with your location code that is setup in Horizon to recover the branch pull list.
