Maximum Hold Limit

Polaris
1

Hello,
Does anyone know if I can use SQL to update the maximum hold limit of a material type? I have to change the max hold limit of a material type for 23 patron codes in 50 branches. I normally change the max hold one by one but, it can take me a week to change the materials type’s max hold limit for 24 patron codes at the 50 branches. Does anyone know a way to speed up the process?

Could I do this

UPDATE MaterialTypes
SET MaxHoldLimit = 3
WHERE MaterialTypeID = ToyKits

2

I think you are looking for something similar to this post. Bulk Change Loan Limits - Clearinghouse Repository / Polaris Repository - Innovative Users Group

1 Like