Is there a way to feed a workflow action a whole result set assembled by a query (the workflow equivalent of looping over a PL/SQL cursor), rather than only being able to read one record via a standard API Read task?

All FAQ questions / Workflows and automation

Answer

Yes — call the QuickReports projection's own generated entity-set/action from within the workflow's API Read task (using the same call syntax and parameters the Quick Report's REST endpoint expects), which lets the workflow iterate over a pre-assembled query result set as its input, functioning as the workflow-level equivalent of driving an action off a PL/SQL cursor's rows.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Workflows and automation questions