Skip to content
View as markdown Ask ChatGPT Ask Claude

Execute Named Query#

Executes a saved query with query security and caller-supplied parameter values.

Screenshot of a Business Workflow executing a saved query with a Prefix input parameter.

Inputs#

Set Query, PageNumber, PageSize in the task details. Use the value editor to select compatible results from earlier tasks.

Named Input Rows#

Use the + button in Inputs to add one row per query parameter. Enter its exact name, select its type, and enter a value or select an earlier result. Keep the fixed inputs. Additional names must be unique and different from the fixed input names.

See Named Input Rows for a worked example.

Outputs#

Use Rows, RowCount, Found, TotalRowCount in subsequent tasks.

Execute Named Query

Select a saved query with a String parameter named Prefix. Add a String row named Prefix and enter the desired prefix. Set paging inputs and consume Rows or project identifiers for Load entities.