The Delete Simple Table Rows task will delete the specified rows from the nominated Simple Table Name.
When using pipebar (|) delimited lists to delete from multiple columns please note you can only match ONE item for each column to delete having specified the columns in the Field Names property and the Items in the Match Values property.
You can not use a pipebar delimited list to delete multiple different items from the same column. You can only delete multiple of the same item from a column.
It is important to make sure that the number of items in the Match Values property is the same as the number of columns specified in the Field Names.
If you specify two columns to look in for the Field Names property you must make sure you have two items specified for the Match Values property as well.
| Property Name | Description |
|---|---|
| Field Names | The column names to match against, delimited by pipe bars "|". |
| Match Values | The values to match against based on the fields specified in the Field Names property. Values should be delimited by pipe bars "|". |
| Table Name | The name of the Simple Table to remove rows from. |
| Title | Changes the Title (not the name) of the task. |
This task has different types of Outputs. For more information about Outputs see Specification Macros Task Node.
Outputs are only available within Specification Macros. Currently Outputs are not available Specification Flow.
| Output Name | Description |
|---|---|
| Deleted Rows Count | This is the number of rows deleted from the table. |
This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.
The status output navigation is as follows:
Success
Success with Warnings
Failed (one of the following occurred)
When this task is added the properties are static by default.
See How To: Change A
Static Property To A Dynamic Property to enable rules to be built on these properties.
| ID | Company Name | City | Country |
|---|---|---|---|
| 1 | Amazon Warriors | Strasbourg | France |
| 2 | Amazon Warriors | Munich | Germany |
| 3 | Super Jets | Treviso | Italy |
| 4 | Super League | Leeds | England |
| 5 | Super League | Granada | Spain |
| Property | Example Rule | Example Result | Meaning |
|---|---|---|---|
| Field Names | "Company Name" | Company Name | Company Name will be used as the Field to match values against. |
| Match Values | "Amazon Warriors" | Amazon Warriors | Amazon Warriors will be looked for in the Simple Table. Matching rows will be deleted. |
| Table Name | "Customers" | Customers | Customers is the name of the Simple Table to delete these rows from. |
| Property | Example Rule | Example Result | Meaning |
|---|---|---|---|
| Field Names | "Company Name|City" | Company Name|City | Company Name and City will be used as the Fields to match values against. |
| Match Values | "Amazon Warriors|Munich" | Amazon Warriors|Munich | Amazon Warriors based in Munich will be looked for in the Simple Table in their corresponding columns. Matching rows will be deleted. |
| Table Name | "Customers" | Customers | Customers is the name of the Simple Table to delete these rows from. |
| ID | Company Name | City | Country |
|---|---|---|---|
| 3 | Super Jets | Treviso | Italy |
| 4 | Super League | Leeds | England |
| 5 | Super League | Granada | Spain |
The Output results for the example would be:
| Output Name | Output Value |
|---|---|
| Deleted Rows Count | 2 |
| ID | Company Name | City | Country |
|---|---|---|---|
| 1 | Amazon Warriors | Strasbourg | France |
| 3 | Super Jets | Treviso | Italy |
| 4 | Super League | Leeds | England |
| 5 | Super League | Granada | Spain |
The Output results for the example would be:
| Output Name | Output Value |
|---|---|
| Deleted Rows Count | 1 |
DriveWorks Tech Tips Portal |
Copy Table Shows how you can copy data from one Simple Table to another, remove selected rows and clear the whole table using macros. Editing Table Data This project shows how to add, edit and delete data from a Simple Table. The methods used in this can be transferred to Group Tables and also SQL Tables. |
DriveWorks Tech Tips Portal is available to DriveWorks Pro customers with an active subscription and support contract. Tech Tips provide cut down projects that highlight specific functionality for faster and more effective learning. To access the portal:
The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require. |