EscalationRuleActions Table

Applies to QAComplete 14.3, last modified on February 19, 2024

Description

If an escalation rule includes actions to take (defined in Step 4 of the rule), the instructions are recorded in the EscalationRuleActions table.

Columns

The table contains the following columns:

ActionId  :  int, primary key, allows null: no

The unique identifier of the escalation rule action.

RuleId  :  int, allows null: no

The numeric identifier of the escalation rule that uses the action.

DateUpdated  :  datetime, allows null: yes

The date and time when the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

FieldName  :  varchar (max 100 chars), allows null: no

The name of the field to update, if configured to do that.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the item.

Value  :  varchar (max), allows null: yes

The value to place in the field, if configured to do that.

This column may correspond to a field that is available for rich editing.

See Also

EscalationRuleActions View
EscalationRules Table
Setup

Highlight search results