Alerts View

Applies to QAComplete 12.84 SaaS, last modified on July 19, 2021

Description

Contains detailed information on the alerts that were created by active users.

Dependencies

Columns

AlertId  :  int, 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 Text Feature.

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 Text Feature.

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.

GroupId  :  int, allows null: yes, default: 0

The ID of the related department or project. Depends on the GroupType value.

GroupType  :  varchar (max 30 chars), allows null: yes

Shows the type of the group identifier (DeptId or ProjId).

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.

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

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

See Also

Alerts Table
Attachments View
Crossmodules

Highlight search results