SWQL table with node caption as a URL

hebridean

I have this SWQL query, to display a traffic lights status icon, node caption and status but the node caption is displayed as plain text, not a clickable URL link to the node details. I cannot get the caption as a URL to work, any ideas?

SELECT
n.Caption AS [Node Name]
, n.DetailsURL AS [_LinkFor_Node Name]
, CONCAT('<img src="/Orion/images/StatusIcons/Small-', n.StatusLED,'"></>') AS Icons
, n.StatusDescription
FROM Orion.Nodes n
JOIN
Orion.ContainerMemberSnapshots cms ON n.NodeID = cms.EntityID
WHERE
cms.ContainerID = 39
ORDER BY n.Caption

Thanks for any help.

flackovic

What is the intended widget for this query? It sounds like a problem using a Custom Table, perhaps within a report? It runs fine in my environment with a Custom Query widget.

If you would like to use this in a Custom Table widget, it would need to be tweaked as such:

SELECT
n.Caption AS [Node Name]
, n.DetailsURL AS [_LinkFor_Node Name]
, n.Status
, n.ChildStatus
, n.StatusDescription
FROM Orion.Nodes n
JOIN
Orion.ContainerMemberSnapshots cms ON n.NodeID = cms.EntityID
WHERE
cms.ContainerID = 39
ORDER BY n.Caption

When you add the Node Name to the table, you could then use the following settings to make sure the Page Link and the Status Icon works: