DashboardTemplateWidget Table

The widgets associated with a dashboard template.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for DashboardTemplateWidget table

Database Column

Details

DashboardTemplateWidgetID

Type: integer. Key. Generated ID

Unique identifier of a dashboard template widget, this is a primary key.

DashboardTemplateID

Type: integer. Key

Unique identifier of a dashboard template ID. Foreign key to the DashboardTemplate table.

DashboardWidgetID

Type: integer. Key

The id of a dashboard widget being referenced. Foreign key to the DashboardWidget table.

DisplayOrder

Type: integer. Key

The order to display the widget.

CustomSettings

Type: text. Nullable

The default custom widget settings.

Comment

Type: text (max 256 characters). Nullable

The comment for the widget.

IsShared

Type: boolean