Rows to Return

This property box determines how many rows the Query Data and Custom Query activities will return.

Note: If you chose to have these activities return more than one row, you can access the token values for the additional rows with the For Each Row activity.

To configure Rows to Return

  1. Add the Query Data or Custom Query activity to your workflow definition by dragging it from the Toolbox Pane and dropping it in the Designer Pane.
  2. Select the activity in the Designer Pane.
  3. Under ClosedRows to Return in the Properties Pane, specify how many rows you want returned.

    • First row only: Returns the first row in the database that contains the queried value. The database is searched from the top down.
    • First ___ rows: Returns the first specified number of rows that contain the queried value. Type in the desired number of rows, or use the scroll box (up-and-down arrows) to select a number of rows. Alternatively, click the Token button (right arrow) to use tokens. The database is searched from the top down.
    • All Rows: Returns all rows that contain the queried value.