Search Rows

Find rows in a table that match a set of conditions.

Options

Field Definition Type Required
Table ID (if the provide table at runtime option was selected) ID for table. To obtain the table ID, see Provide a table ID at runtime.

To select a table:

  1. Click Choose Table, select a table in the dialog box, or click New Table to create a new table, then click Choose.

  2. Click Save on the card.

String TRUE
Result Set Filter the results of your search:
  • First matching row: Returns the first row that matches your search criteria. Use this option when searching for a specific row.

  • All matching rows: Returns all matching rows as a list. Use this option when searching for the maximum amount of data that matches your search criteria.

A result set is based on a match of a full or partial string. For example, if you use “joe” as a search value, the search results will include all rows that include a value of "joe" in one of columns.

Dropdown TRUE
Various To select the fields (column names) that will be returned in the search results:
  1. Click the check boxes next to the available listed input fields.

  2. Click Save.

Input

Field Definition Type Required
Filter
Where Expression Click Filter to build search conditions. In the dialog box, select which table column to search. Optionally, drag and drop outputs from previous steps into the Value input if you want to search based on a value that comes from earlier in your flow, such as a customer ID. Click + Add condition to search based on more than one test, such as Customer Type = Trial and Date > 1/1/18. The search expression is case sensitive. Dialog Box TRUE
Sort
Column Specific column to sort results by. Dropdown FALSE
Direction Direction of the search. Select Ascending (A to Z, 0 to 9) or Descending (Z to A, 9 to 0). Dropdown FALSE
Limit Maximum number of records to return. If a filter or limit is not applied to the table search, a maximum of 3,500 rows from the selected table will be read by the Search Rows function card. Number FALSE
Offset Record number at which the search starts, where zero is the first record. Number FALSE
Table ID (if provide table at runtime option is selected) Select a table from which a row will be read. String TRUE

Output

If you're returning a single result, the following outputs are returned:

Field Definition Type
Row
Created Date and time when the row was created. Date & Time
Updated Date and time when the row was last updated. Date & Time
Fields
The chosen fields (column names) from the table you selected. If the table is provided at runtime, you can manually add the field names and types.

If you're returning multiple results, a list of rows is returned, where each row includes all of the above, or an empty list if zero matching rows is returned if none were found.

Related topics

Functions in Workflows

Workflow elements