We get this when clicking Get List on a updatable BAQ. I remember in the past a consultant said we could write a baq report that could be put on a schedule to update data overnight. Never figured out how that was done.
Is it possible? When I try to Get List it only fires the BPM once, not once per line. How can an updatable baq just run and change data? I can set fields but when I hit update it reports that no rows were updated.
Before @LoganS suggests it, I want to do it without C# 
But I’m working on such a lovely c# script… probably missing something in there because it complains
Tough luck, unless you really like widgets.
Even if I love widgets how do you get it to fire on each record instead of once per get list?
first off, instead of using a UBAQ to do this, since you now have Epicor FUNCTIONS, you should consider using that instead. Within a Function, you can specify actions to happen, and you can schedule functions to run on a schedule.
Even if I used a function, is there a way, for example, to check checkbox01 on every record of table UD02 without using a code block? I’m just looking for something easier than scheduling a pull-push DMT batch file on the server. If I was steered wrong back in the day that’s fine too.
Update By Query Widget
There must be some black magic involved, I can’t get anything in a scheduled function to update more than one line.
It only does what you code it to do.
You have to iterate the rows somehow.
You have to set the row mods if you are changing in a post processing get list, and allow multiple dirty rows on your UBAQ.
You can change stuff in the database by calling… other stuff (gestures wildly indicating nothing specific).
But like @klincecum said, you have to iterate through the rows, which is a large PITA with widgets.
Go vote for this. It’s a long overdue widget for Epicor to implement.
https://epicor-manufacturing.ideas.aha.io/ideas/KIN-I-3866
I’m still not up to snuff on the widgets, can this be done with @Mark_Wonsil 's suggestion to use update table by query?
maybe? I learned to code before I figured out how that widget worked. 
