I am trying to develop a workflow for managing missing items using the On Search file in Sierra. Is it possible in Global Update to do the following:
On the 'On Search' review file of item records
if ICODE1 = 2, then change STATUS to F and change ICODE1 to 3
if ICODE1 = 1 then change ICODE1 to 2
if ICODE1 = 0 then change ICODE1 to 1
I would like this as a single command in Global Update instead of having to create 4 separate review files.
UC Hastings College of the Law