Skip Ribbon Commands
Skip to main content
SharePoint

Updating Records that Meet Specific Criteria

To update records in the database table, that meet specific criteria, complete the following steps:
  1. Check out and open the process you want to edit.

  2. In the Toolbox pane, click Database. A list of activities is displayed.

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

  4. Link the activity appropriately with other activities.

  5. Right-click the Update Database Records activity, a shortcut menu is displayed,

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

  7. Click the Database and Table tab. The Database and Table to Update section is displayed.

  8. In the Database field, click the System Resource icon. A drop-down list is displayed.

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

  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.

    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.


  12. Click the Update Criteria tab. The Update Criteria options are displayed.

  13. Select the Update records That Meet the Following Criteria check box.

  14. Select the update criteria you want to use to update database records from the following:

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

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

    Note:
    To add more criteria values, click the plus sign and repeat step 9.
    To remove the criteria values, click the minus sign (−).


  16. Click the Data Mapping: Update Records tab. The corresponding screen is displayed.

  17. Select either the automatic or manual option for mapping values to table columns.

    Note:
    For details on automatic and manual mapping options, see the corresponding topics in this section.


  18. Click OK. You configured the database activity to update specific database records.
Related Topics
Updating All the Records in the Database Table
Automatically Determining which Columns to Update with Data Item Values
Manually Determining which Columns to Update with Data Item Values, Expression Results, or Literal Values
Rolling Back and Undoing Updates to Records when an Error Occurs

Source
BPM Designer Topics > Overview of Activities and Activity Topics > Database Activities > Update Database Records
Last modified at 7/31/2020 12:05 PM