Description
Stores built-in and custom alerts of all the projects.
Columns
The table contains the following columns:
AlertId : int, primary key, allows null: no
The unique identifier of the alert.
AlertMessage : varchar (max 8000 chars), allows null: yes
The text of the alert message.
This column corresponds to a field that can be available for rich editing.
AppCode : varchar (max 100 chars), allows null: no
The type of the application. agSP corresponds to QAComplete SaaS; agSPEnt corresponds to QAComplete On-Premises.
ColName : varchar (max 30 chars), allows null: yes
The name of the column whose value triggers the alert (for custom alerts).
DateCreated : datetime, allows null: no, default: Current date and time
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: no, default: Current date and time
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.
DeptId : int, allows null: yes, default: (0)
The ID of the department that owns the alert.
Description : varchar (max 255 chars), allows null: no
A description of the alert.
This column corresponds to a field that can be available for rich editing.
EntityCode : varchar (max 100 chars), allows null: no
The module that uses the alert.
You can find correspondences between entity code values and related modules in Table of Entity Code Values.
EventRule : varchar (max 30 chars), allows null: no
The event that triggers the alert.
IsEmail : char (max 1 char), allows null: no, default: N
The column is reserved for system use only.
IsFax : char (max 1 char), allows null: no, default: N
The column is reserved for system use only.
IsInbox : char (max 1 char), allows null: no, default: N
The column is reserved for system use only.
ListTypeCode : varchar (max 100 chars), allows null: yes
The name of the list for which the alert was created.
OnUpdateValue : varchar (max 1000 chars), allows null: yes
The custom alert triggers when this value is set in the corresponding column.
Title : varchar (max 100 chars), allows null: no
The name of the alert.
UpdateUserId : int, allows null: no
The ID of the user who last updated the item.
UserId : int, allows null: no
The ID of the user that owns the alert.