I’ve been going around in circles trying to get this working with transaction groups, but i’m not sure its possible with how they are designed to work.
I have a table of Maintenance tasks, with the following columns:
UUID, MC_ID, CurrRunMins
I would like the transaction group to be set up to update the MachineRunTime column for ANY row that has a MachineID as specified in the transaction group.
So no matter how many tasks (rows) i have, one transaction group will update machine run time for that specified machine, for any tasks that match.
I have tried using a standard group, but i noticed that when using a custom update, it does a query like:
SELECT UUID FROM MaintTasks WHERE MC_ID = ID LIMIT 1
Clearly i don’t want the “LIMIT 1” part here.
So i tried using a Block Transaction group, but can’t get that to work either.
I originally used a script but it took quite a long time to execute because it required looping through tags, so i don’t really want to have to revert to that.
Any tips would be greatly appreciated.