DashboardPages Table

Applies to QAComplete 12.93 SaaS, last modified on November 01, 2021

Description

Stores the settings of all dashboard pages (tabs).

Columns

The table contains the following columns:

DashboardPageId  :  int, primary key, allows null: no

The unique item identifier.

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

The type of the application. agSP corresponds to QAComplete SaaS; agSPEnt corresponds to QAComplete On-Premises.

CreateUserId  :  int, allows null: no

The ID of the user who created the item.

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

The caption of the dashboard page (tab).

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

The name of the dashboard page (tab).

DateCreated  :  datetime, allows null: no

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

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: no

The ID of the department that owns the dashboard.

isActive  :  varchar (max 1 char), allows null: no, default: Y

Indicates whether the item is active.

isPublic  :  varchar (max 1 char), allows null: no, default: Y

Indicates whether the page is published.

SecurityEntity  :  varchar (max 200 chars), allows null: yes

The name of the entity that controls the page (tab).

SortOrder  :  int, allows null: yes

The ordinal number of the page (tab) among other dashboard pages of the module.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

DashboardPageItems Table
DashboardPages View
Dashboards

Highlight search results