Skip Ribbon Commands
Skip to main content
SharePoint

Manually Determining which Data Items to Populate with Database Column Values

To manually determine which columns to populate with database column values, complete the following steps:
  1. Check out and open the process you want to edit.

  2. Open the database activity in the process that you previously configured and now want to edit.

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

  4. Select the Manually Map Data Items to Column Fields check box.

  5. Select the database column, and data type from the corresponding fields.

  6. In the Data Item to store value field, select the appropriate input field editor and set the field to a value.

    Note:
    Calculation data items are read-only. You cannot edit this type of data item.

      
    Note:
    To map more data items click the plus sign (+) and repeat steps 14 and 15.
    To remove data item mappings, click the minus sign (−).


  7. Click OK. You manually determined which columns to populate with database column values.

    Note:
    If you also select the Automatically Map Data Items to Column Fields check box, then the manual mapping will override any automatic mappings the Process Engine detects.
Related Topics
Retrieving All Records from a Database Table or View
Retrieving Specific Records from a Database Table or View
Automatically 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:50 AM