Turn on more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
SharePoint

Delete Specific Records from a Database Table

Important StatusThe current page has been customized from its template.
To delete specific records from a database table, complete the following steps:
  1. Check out and open the process you want to edit.

  2. In the Toolbox pane, click Database. A drop-down list is displayed.

  3. Double-click or drag the Delete Database Records activity into the process.

  4. Link the activity appropriately with other activities.

  5. Right-click the Delete Database Records activity. A shortcut menu is displayed.

  6. Select View Properties. The Delete Database Records window is displayed.

  7. Click the Database and Table tab. The Database and Table to Delete Records from section is displayed.

  8. In the Database field, click the System Resource icon. A list of the ODBC System Resources is displayed.

  9. Select the relevant ODBC System Resource. The selected resource is displayed in the field.

    Note:
    If your system resource contains a data item in the connection string property, click Configuration Values and enter a valid connection string for design-time, configuration purposes.


  10. In the Table field, click the Table icon. A drop-down list is displayed.

  11. Select the relevant database table. The selected table’s name is displayed in the field.

  12. Click the Deletion Criteria tab. The corresponding screen is displayed.

  13. Select the deletion criteria you want to use to delete database records from the following: 

    Delete records that meet all of the following criteria
    Delete records that meet one or more of the following criteria
    Delete records that do not meet any of the following criteria
    Delete records that do not meet one or more of the following criteria

  14. Select the required options from the Database column, Data type, Filter condition value, and the Value to filter on fields.

    Note:
    Add more criteria values, click the plus sign and repeat step 14.


  15. Select the If the deletion action on any record fails, rollback and undo all deletions check box.

  16. Click OK. You configured the activity to delete specific records from a database table.
Related Topics
Delete Specific Records from a Database Table

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Database Activities > Delete Database Records
Last modified at 7/31/2020 11:33 AM