Settings and activity
10 results found
-
4 votes
Cameron C
shared this idea
·
-
34 votes
An error occurred while saving the comment -
30 votesCameron C
supported this idea
·
-
12 votesCameron C
shared this idea
·
-
3 votesCameron C
shared this idea
·
-
14 votesCameron C
supported this idea
·
-
2 votesCameron C
shared this idea
·
-
92 votes
An error occurred while saving the comment Cameron C
commented
I was surprised to learn there was such a blip in status changes not triggering holds... we only noticed it with a recent spate of such 'not supplied' holds. I did not see anything in the IUG forum about this, so I'm glad to see some others have experienced it and are bringing awareness to it!
Cameron C
supported this idea
·
-
4 votesCameron C
shared this idea
·
-
13 votesCameron C
supported this idea
·
We learned recently that there's a workaround to this - through the power of SQL and a neat trick to get SQL to run in the Weeding Template criteria: the magic of the ADHOC!
The following is a very basic example of how you could have a weeding template filter by a relative last check in date (we also found out recently that, despite the name, last circ date includes things like inventory check-in or item record modification and was less useful as a parameter for weeding):
ADHOC="SELECT ItemRecordID FROM CircItemRecords WHERE AssignedCollectionID = int AND CheckInDate < DATEADD(year, -int, CURRENT_TIMESTAMP)"
The above example has to go into the inclusion criteria field with the ADHOC=" " in order to work, and the int values would correspond with your given collection and number of years from the current date you wanted to include.