Ticket #29112
Question
Is there a way to submit a grid update in a one step fashion? Basically I am trying to change a status value on a set of 12 rows without having to write some complex SQL or a business rule.
Answer
Informed customer such a task may be accomplished using the Workflow Designer tool (See here for more information https://www.mrc-productivity.com/docs/maint/workflow-designer). As a high level overview, you can build a Single Row maintainer (a dummy/prompt maintainer) that passes the necessary parameter(s) needed to identify the 12 records to be updated, and pass that parameter to the Lookup action in the workflow. Then an additional workflow step could be called to update the data retrieved from the lookup.
Asked on June 11, 2019