Delete Row

The Delete Row step allows you to delete a row in a table by a given condition.

You need to specify the filter condition to find the row to delete, for example:

// id = 23
{{ui.table.deletedRow.data.id}}

You can also specify multiple conditions. In this case, the row will be deleted if all conditions are met.

The condition(s) you specify will be sent to the server and converted to a DELETE statement, for example:

DELETE FROM users WHERE id = 23

You can check the action's Payload tab to see the actual conditions sent to the server.

Filters with empty values are omitted from the generated WHERE clause. This applies to null, undefined, an empty string, an empty array, and an array containing only empty values.

An empty array used with IN does not create a condition that matches zero rows. The filter is removed instead. For example:

id IN [] AND status = 'inactive'

is evaluated as:

status = 'inactive'

This can delete unintended rows. If all filters are removed and Bulk Delete is enabled, the action can delete every row in the table.

Validate dynamic filter values before running the action. For bulk operations, add a Condition step before the Delete Row step.

No rows will be deleted if the conditions aren't met.

Additional settings

If you need to delete multiple rows, you can select the Bulk Delete checkbox in the action's settings.

We recommend being very careful with this setting since it can delete all rows in the table.