# Search records action (batch)
The Search records batch action retrieves a list of entries that match the search criteria you specify from a data table.
# Input
Input fields | Description |
---|---|
Data table | Select the data table you plan to search. Click the link in this field's description to view the selected data table. |
Filters | Add filters to the query. Filters are chained using AND logic. This field has some additional sub-fields:
|
Sort by | Select a property to sort the results by. |
Sort direction | Select whether to order search results in Ascending or Descending order. |
Limit | Enter the maximum number of entries you plan to retrieve each trigger event. The default value is 100 and the maximum is 200 . |
Next page token | Optional. Provide the token from a previous response here to return the next page of results. |
Choose the desired output format | Optional. Specify how to map the retrieved record data to the table fields. Refer to the Output formats section for more information. |
# Output
Output fields | Description |
---|---|
Records | Contains information about the retrieved records, such as their Record ID , List index , Updated at timestamp, and data from any of the data table's custom columns. |
Next page token | The token for the next page of results. |
# Available operands
The operands you can use to filter your data table vary based on your selected column's data type:
Short text
The following operands are available:
- Equals
- Is not equal to
- Starts with
- Is null
- Is not null
Long text
The following operands are available:
- Equals
- Is not equal to
- Starts with
- Is null
- Is not null
Integer
The following operands are available:
- Equals
- Is not equal to
- Is less than
- Is greater than
- Is less or equals
- Is greater or equals
- Is null
- Is not null
Decimal
The following operands are available:
- Equals
- Is not equal to
- Is less than
- Is greater than
- Is less or equals
- Is greater or equals
- Is null
- Is not null
Boolean
The following operands are available:
- Is true
- Is false
- Is null
- Is not null
Date
The following operands are available:
- Equals
- Is not equal to
- Is before
- Is after
- Is on or before
- Is on or after
- Is null
- Is not null
DateTime
The following operands are available:
- Equals
- Is not equal to
- Is before
- Is after
- Is on or before
- Is on or after
- Is null
- Is not null
Link to a table
The following operands are available:
- Equals
- Is not equal to
- In
- Is null
- Is not null
File
The following operands are available:
- Equals
- Is not equal to
- Is null
- Is not null
Multi-value
The following operands are available:
- Contains
- Is not null
- Is null
Last updated: 2/18/2025, 8:26:30 PM