Modern Dashboard - Widgets No Results Issue

So I created a table widget in the dashboard that would show any components that are not up. Well because all of them are up, there are no results displayed. When looking at the widget it doesn't return the column headers just a stupid box and database symbol.

Can this be fixed? It should either return the header columns that are defined with no results or you need to add a way to enter what we want to display if no results are returned.

Find more posts tagged with

Accepted answers

All comments

neomatrix1217

Can you share the data model that you are using?

jfoudy

Here's one that anyone can use. This one should always return no results because there is no node with a negative number.

Select TOP 10 NodeID, Caption
FROM Orion.Nodes
WHERE NodeID = -1

This is the one I was using in the example above:
SELECT n.Caption as NodeName,c1.ComponentName,c1.DetailsUrl as ComponentDetailsUrl,c1.Disabled,c1.DisplayName,c1.Image,c1.Status,c1.StatusDescription,c1.Uri,c1.UserDescription,c1.UserNotes
FROM Orion.APM.Component c1
LEFT JOIN(
SELECT
NodeID,InstanceSiteId,ApplicationID
FROM Orion.APM.Application) a
on a.ApplicationID = c1.ApplicationID
LEFT JOIN (
SELECT NodeID,InstanceSiteId ,Caption,n1.Status as NodeStatus, n1.DetailsUrl as NodeDetailsUrl, n1.CustomProperties.AssetTag as AssetTag, n1.CustomProperties.Environment as Environment
FROM Orion.Nodes n1
) n ON a.NodeID=n.NodeID AND a.InstanceSiteId=n.InstanceSiteId
WHERE (n.AssetTag= 'SQL' and n.Environment= 'Production' ) --OUR CUSTOM FIELDS PLEASE REMOVE/EDIT THESE AS NEEDED
and c1.Status <> 1