Are you an LLM? You can read better optimized documentation at /en/data-tables/connector/delete-records-condition-action.md for this page in Markdown format
Delete records by condition action (batch)
The Delete records by condition batch action deletes all records that match the filter conditions you specify in a data table. This action supports the following maximum batch size:
| Description | Limit |
|---|
| Maximum batch size for all Data table connector batch actions | 1,000 |
| Input fields | Description |
|---|
| Data table | Select the data table to delete records from. Click the link in this field's description to view the selected data table in the Data tables interface. |
| Filters | Define the conditions a record must meet before this action deletes it. Each filter contains a Column name, Operand, and Value field. Click Add filter to add filters for additional columns. The available operands vary based on the selected column's type. Refer to Available operands by column type for supported options. |
Output
| Output fields | Description |
|---|
| Deleted records count | Total number of records this action deleted. |
Available operands by column type
The following table lists the operands available for each data table column type.
| Column type | Available operands |
|---|
| ID | equals, not equals |
| String, File | equals, not equals, is null, is not null, starts with |
| Integer, Number | equals, not equals, greater than, less than, greater than or equals, less than or equals, is null, is not null |
| Date, Date-time | equals, not equals, is after, is before, is on or after, is on or before, is null, is not null |
| Boolean | is true, is false, is null, is not null |
| Relation | equals, not equals, in, is null, is not null |
| Set types (string set, number set, integer set, date set, date-time set, relation set) | contains, is null, is not null |