1. Business Process Framework: Workflow Guide
  2. Configuring a Workflow Policy Condition That References a Foreign Key

Configuring a Workflow Policy Condition That References a Foreign Key

You can configure a Workflow Policy condition that references a foreign key that resides in the primary table of the Workflow Policy object. For example:

S_OPTY.CURR_STG_ID

where:

  • S_OPTY is the primary table of the Opportunity workflow object

  • CURR_STG_ID is a foreign key from the NAME column of the S_STG table

To configure a Workflow Policy condition that references a foreign key

  1. In the Object Explorer in the Workflow Policy Columns list, add a new Workflow Policy column with values shown in the following table.

    Property Value

    Name

    S_STG.NAME

  2. Add a new Workflow Policy component to the Opportunity Workflow Policy object that references the S_STG table, with the values shown in the following table.

    Property Value

    Name

    Enter a name of your choice

    Source Table Name

    S_STG

    Source Column Name

    ROW_ID

    Target Component Name

    Opportunity

    Target Column Name

    CURR_STG_ID

  3. Add the new column (step 1) to the new Workflow Process component that you configured in step 2.

    You can now configure a Workflow Policy condition that references the new Workflow Policy column.