cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 10

Icon for Node Status [Custom Query]

Jump to solution

Hi,

i created an custom query widget with this SWQL-Query:

SELECT
n.Status,
n.Caption,
n.NodeiD,
'/Orion/images/StatusIcons/small-' + n.StatusIcon AS [_IconFor_Status]
FROM Orion.Nodes n
WHERE NodeID > 4400

The result looks like this:

pastedImage_1.png

Is it possible to remove the status shown as digit and just show the icon?

Greetings

Dominik

0 Kudos
1 Solution
Level 10

Found the solution

changed the query to the following

SELECT
n.Caption,
n.NodeiD,
'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Caption]
FROM Orion.Nodes n
WHERE NodeID > 4400

Result:

pastedImage_0.png

View solution in original post

1 Reply
Level 10

Found the solution

changed the query to the following

SELECT
n.Caption,
n.NodeiD,
'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Caption]
FROM Orion.Nodes n
WHERE NodeID > 4400

Result:

pastedImage_0.png

View solution in original post