Delete rows

Use the Tables - Delete rows action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to delete rows from a table. You can delete specific rows from the table by specifying conditions. If no conditions are applied, all the rows in the table will be deleted.

Note: The maximum number of rows that can be deleted in a table using the Delete rows action is 1000.

For more information about Nintex Tables, see Tables.

Configure the Tables - Delete rows action

1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

2. Select the table you want to delete rows from in Table name field.
3. Add conditions to specify which rows should be deleted from the table. The rows that meet the specified conditions are deleted.

   Note:  If no conditions are applied, all the rows in the table will be deleted.

4. Create or select a variable to store the action output in Result.

Tables - Delete rows action fields and settings

Section	Field	Description	Variable types
Table	Table name	The name of the table from which you want to delete rows.	Text, Decimal, Integer, Boolean, DateTime, Collection
Conditions	Add conditions / Edit conditions	Conditions to specify the rows you want to delete. Note:  If no conditions are applied, all the rows in the table will be deleted. The condition builder is displayed. Add conditions: Displayed when there are no existing conditions specified for the action. Edit conditions: Displayed when there are existing conditions set for the action. You can edit the conditions. If you want to delete more than one row, create multiple conditions and select the And or Or options accordingly. For more information the condition builder and the fields, see Condition builder.	(varies)
Output	Result	Stores the result of the action as an object with the following variable: Deleted row count: (Integer) The number of rows deleted.	Object