Join Wintertainment 2021 to share your stories, have fun, earn community badges, and more!

EscalationRules View

Applies to QAComplete 12.94 SaaS, last modified on December 06, 2021

Description

Contains detailed information on escalation rules.

Dependencies

Columns

ApplyOrder  :  int, allows null: no

The order in which to apply the rule.

CreateUserId  :  int, allows null: yes

The ID of the user who created the item.

DateCreated  :  datetime, allows null: yes

The date and time when the item was created.

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

DateUpdated  :  datetime, allows null: yes

The date and time 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.

Description  :  varchar (max), allows null: yes

The description of the rule.

Duration  :  int, allows null: no

The duration to wait for the rule to fire.

DurationUnits  :  varchar (max 50 chars), allows null: no

The time measurement for the duration (minutes, hours, days, weeks, months, or years).

EmailSubject  :  varchar (max 255 chars), allows null: yes

The subject of the email that the rule generates.

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

The module where the rule is used.

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

FilterId  :  int, allows null: yes

The ID of the filter that is used as a criterion to activate the rule.

FromName  :  varchar (max 100 chars), allows null: yes

The email address from which the rule sends the generated message.

IsActive  :  varchar (max 1 char), allows null: no

Indicates whether the escalation rule is active.

NotifyEmails  :  varchar (max), allows null: yes

The email address for notifications generated by the rule. [OwnerName] and [AssignedToName] correspond to the email address of the item owner and of the user to whom the item is assigned.

OwnerName  :  varchar (max 78 chars), allows null: yes

The name of the user who created the rule, in the Last name, First name format.

ProjId  :  int, allows null: no

The ID of the project that contains the rule.

RuleId  :  int, allows null: no

The unique identifier of the escalation rule.

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

The status of the rule.

TemplateId  :  int, allows null: yes

The ID of the email template that is used in the rule.

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

The name of the template.

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

The title of the escalation rule.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the item.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the rule, in the Last name, First name format.

See Also

EscalationRules Table
EscalationRuleActions Table
Setup

Highlight search results