Description
The GalleryItems table holds the definition of each dashboard chart that exists on the dashboard pages (tabs). On-Premises customers can modify and create custom dashboard charts.
Columns
The table contains the following columns:
GalleryItemId : int, primary key, allows null: no
The unique numeric identifier of the item.
AppCode : varchar (max 100 chars), allows null: no
The column is reserved for system use only.
Behavior : varchar (max 255 chars), allows null: yes
The column is reserved for system use only.
Colors : varchar (max 255 chars), allows null: yes
A list of colors (in hex format) used for the data series.
ConnectionString : varchar (max 255 chars), allows null: yes
A string used to connect to an external database.
CreateUserId : int, allows null: no
The ID of the user who created the chart.
DateCreated : datetime, allows null: no
The date and time when the chart 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 chart 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 gallery item.
DrillDownSQL : varchar (max), allows null: yes
An SQL statement that shows the details when you click on the chart.
DropDownSQL : varchar (max), allows null: yes
The column is reserved for system use only.
EntityCode : varchar (max 100 chars), allows null: no
The module where the dashboard is located.
You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.
ExcludedSQL : varchar (max), allows null: yes
An SQL statement that counts the excluded items.
ExtendAttributes : varchar (max 1000 chars), allows null: yes
An XML string that is used to set the background color, font, and so on.
GalleryItemCaption : varchar (max 100 chars), allows null: no
The caption of the chart.
GalleryItemName : varchar (max 100 chars), allows null: no
The name of the chart.
GalleryItemSQL : varchar (max), allows null: yes
An SQL statement that generates the chart data.
GalleryItemType : varchar (max 50 chars), allows null: no
The type of the dashboard chart (Line Chart, 2D Bar Chart, 3D Pie Chart, and so on).
isActive : varchar (max 1 char), allows null: no, default: Y
Indicates whether the chart is active.
isPublic : varchar (max 1 char), allows null: no, default: Y
Indicates whether the chart is public.
LinkTemplate : varchar (max 255 chars), allows null: yes
The column is reserved for system use only.
ProjId : int, allows null: yes
The column is reserved for system use only.
SecurityEntity : varchar (max 200 chars), allows null: yes
The security module that secures the dashboard chart.
SubCaption : varchar (max 100 chars), allows null: yes
The second line of the chart’s caption.
UpdateUserId : int, allows null: no
The ID of the user who last updated the item.