I created a dashboard with a widget with this query:
--SWQL
SELECT
DashboardID AS [Dashboard ID]
,DisplayName As [Name]
,Description
,ParentID AS [Parent ID]
,Feature
,TOLOCAL (LastUpdate) AS [Last Modification]
,Private
,IsSystem As [System Dashboard]
,CONCAT('/apps/platform/dashboard/', DashboardID) AS [URI]
FROM Orion.Dashboards.Instances
Where Private = 'False'
and IsSystem = 'False'
order by DisplayName
It works great. However, the Description is always NULL. There is not a method I am aware of to add a custom property for dashboards (proved also by the query below). Unlike Reports, there is not a description field when creating one.
--SWQL
SELECT Distinct
InstanceType
FROM System.CustomPropertiesEntity
My management wants that description field populated. I cannot even find a spot to enter the description, even in SQL. I entered this table and went through all the tables that made sense and many that didnt. See SQL code:
--SQL
SELECT T.name AS Table_Name,
C.name AS Column_Name,
P.name AS Data_Type,
P.max_length AS Size,
CAST(P.precision AS VARCHAR) + '/' + CAST(P.scale AS VARCHAR) AS Precision_Scale
FROM sys.objects AS T
JOIN sys.columns AS C ON T.object_id = C.object_id
JOIN sys.types AS P ON C.system_type_id = P.system_type_id
Where C.Name = 'Description'
Order by T.Name
I know I am not the only user who would need something like this. I am sure I will be told to make a suggestion, but I have never had luck with that.
Anyone have any ideas? I know support will tell me this is a customization, so I am not wasting supports time with this.