Skip Ribbon Commands
Skip to main content
SharePoint

Retrieving Specific Records from a Database Table or View

To retrieve 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 Retrieve Database Records activity into the process.

  4. Link the activity appropriately with other activities.

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

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

  7. Click the Database and Table or View tab. The Database and Table to Retrieve Records from 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.

    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 or view 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 Retrieval Criteria tab. The corresponding screen is displayed.

  13. Select the Retrieve records that meet the following criteria option.

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

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

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

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


  16. Click the Data Mappings: Store Records tab. The corresponding screen is displayed.

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

  18. Click OK. You configured the activity to retrieve specific records from a database table.
Related Topics
Retrieving All Records from a Database Table or View
Automatically Determining which Data Items to Populate with Database Column Values
Manually Determining which Data Items to Populate with Database Column Values
Exporting Retrieved Database Records to an XML File

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