Find rows in a Table that match a provided set of conditions.

Options

The first step for using this function is to provide the Table you want to search. Click the “Choose Table” button and select the table you want to use.

If your FLO will operate on different tables each time, you can choose the advanced option to “provide table at runtime“ which will result in an additional Table input field on the next step.

Then, choose in Result Set whether you want to get the first matching row (a single result) or all matching rows (a list of results).

Click Next to move to the next step.

Choose Fields

Next, you’ll be prompted with a list of fields to choose from. The Outputs section lists all of the column headers available on the table. Check the boxes next to fields you want to be returned with the search results.

Click Done to proceed to Inputs and Outputs.

Inputs:

  • *Filter* - click the button to build your search conditions. The Field dropdown lets you choose which table column to search. You can 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 FLO, 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.
  • Sort
    • Column (dropdown) - which column to sort results by
    • Direction - choose “Ascending” (A to Z, 0 to 9) or “Descending” (Z to A, 9 to 0)
  • Limit - maximum number of records to return
  • Offset - record number to start the search at (where zero is the first record)

  • Table ID - this input field only appears if you’ve selected ”provide table at runtime” in the Options step.

Outputs:

If you’re returning a single result, you get the following outputs:

  • Row
    • Row ID - The ID of the row, or blank if zero matching rows were found
    • Created - Date and time the row was created
    • Updated - Date and time the row was last updated
  • Fields
    • The chosen fields (column names) from the table you selected. (If the table is provided at runtime, you have to manually add the field names and types for the fields you want returned by the search)

If you’re returning multiple results, you get a list of Rows, where each row includes all of the above, or an empty list if zero matching rows were found.