Skip Ribbon Commands
Skip to main content
SharePoint

Manually Detemining which Columns to Populate with Data Item Values, Expression Results, or Literal Values

To manually determine which columns to populate with data item values, expression results, or literal values when writing a record to a database, 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: Create Records tab. The corresponding screen is displayed.

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

  5. In the Database column field, select the database column. The data type column is populated automatically with information from the database.

  6. In the Value to write field, select the appropriate input field editor and set the field to a value that corresponds with the data type.

    Note:
    To map more columns click the plus sign (+) and repeat steps 6 and 7.
    To remove a column mapping, click the minus sign (−).


  7. Click OK. You manually determined which columns to populate with data item values, expression results, or literal values.

    Note:
    If you also select the Automatically Map Data Items to Column Fields check box, then the manual mappings will override any automatic mappings the Process Engine detects.
Related Topics
Writing a New Record to a Database Table
Writing Multiple Records to a Database Table
Rolling Back and Removing New Records when an Error Occurs
Saving the Identity of a New Database Record to a Data Item
Automatically Determining which Columns to Populate with Data Item Values

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