Open topic with navigation

FEEDALERTINSTANCEWORKFLOWTRIGGER (4.0SP20)

Stores a list of feed alert instances that trigger workflows.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

FEEDALERTINSTANCEID

uniqueidentifier

false

The ID of the feed alert instance that will trigger a workflow.

WORKFLOWID

uniqueidentifier

false

The ID of the workflow that will be triggered when the feed alert instance is processed.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

WORKFLOWARGSMAP

xml

true

Describes the field mapping between the fields in the feed alert instance datalist and the workflow form.

ENABLED

bit

false

1

Indicates whether or not the trigger is enabled

DATELASTPROCESSED

datetime

true

Indicates the date when the trigger was last processed

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_FEEDALERTINSTANCEWORKFLOWTRIGGER_DATEADDED

DATEADDED

False

False

True

IX_FEEDALERTINSTANCEWORKFLOWTRIGGER_DATECHANGED

DATECHANGED

False

False

False

PK_FEEDALERTINSTANCEWORKFLOWTRIGGER

ID

True

True

False

UIX_FEEDALERTINSTANCEWORKFLOWTRIGGER_FEEDALERTINSTANCEID_WORKFLOWID

FEEDALERTINSTANCEID

WORKFLOWID

True

False

False
Triggers
Trigger Name Description

TR_FEEDALERTINSTANCEWORKFLOWTRIGGER_AUDIT_UPDATE

TR_FEEDALERTINSTANCEWORKFLOWTRIGGER_AUDIT_DELETE