Hi everyone,
I am looking for a way to replace an update statemnt like below with form script in Syteline. The only way i can think of is to load this collection and loop through every single record and perform an update. Please let me know if there's an easier way to accomplish this. Thank you so much for your help.
update item set stat = 'O' where stat='I'