Join Spec (O)

Specifies an additional join between this workflow policy component and the target workflow policy component, when the existing join is to an intersection table and would therefore return multiple rows. The second join restricts the relationship so that only one row is returned at a time. The expression entered in the property is equivalent to an additional WHERE clause in SQL, and it takes the form:

workflow_component.foreign_key = business_component.primary_key

Example: The following join specification occurs in the Primary Opportunity/Position workflow policy component in the Opportunity workflow object:

[Primary Opportunity/Position].OPTY_ID = [Opportunity].ROW_ID

The component named must be in brackets.

Name (R)

The name of the workflow policy component.

Primary (O)

A TRUE or FALSE value indicating whether this workflow policy component is the primary one for the parent workflow policy object definition.

Each workflow policy object definition must have one (and only one) primary workflow policy component.

TRUE = The workflow policy component is the primary one.

Source Column Name (O)

The column in the source table that relates to another workflow policy component. This is from a drop-down list of columns from the table specified in the Source Table Name property.

Source Table Name (R)

The table that the workflow policy component is based on. This is a table name from the drop-down list.

Target Column Name (O)

The column in the target workflow policy component that the source column in this workflow policy component is joined to. This is selected from a drop-down list of columns from the table specified in the target workflow policy component.

Target Component Name (O)

The target workflow policy component that this workflow policy component is related to. This is a component name from the list of workflow policy components for the current workflow policy object.