Modern Dashboard with Icon based on Custom Field properties data

alanaraki

Hi everyone.

I’m currently building a custom License Management dashboard using a Modern Table Widget in SolarWinds Platform (version 2025.4.0), and I’m running into an issue with icon rendering in a custom SWQL driven column.

I'm using a custom SWQL query to display license details stored in Node Custom Properties, including a status field (License_Status) and a derived column (StatusIcon) for icon mapping.

I'd expect:

Active → 🟢 Active (status_up)
Renewal → 🟡 Renewal (status_warning)
Expired → 🔴 Expired (status_down)

Configuration:
The column is set to Format: Icon Value
The Icon field is required, so I must select a value (e.g status_up)
The widget always displays the selected icon (green) regardless of the SWQL output

Even though the StatusIcon column returns correct values and the License_Status field displays correct text, the icon does not dynamically change per row.

SELECT
n.Caption AS NodeName,
ncp.License_Product,
ncp.License_Name,
ncp.License_Expiry,
ncp.License_Owner,
ncp.License_Status,

-- Icon mapping
CASE
WHEN ncp.License_Status = 'Active' THEN 'status_up'
WHEN ncp.License_Status = 'Renewal' THEN 'status_warning'
WHEN ncp.License_Status = 'Expired' THEN 'status_down'
ELSE 'status_unknown'
END AS StatusIcon

FROM Orion.Nodes n
JOIN Orion.NodesCustomProperties ncp
  ON n.NodeID = ncp.NodeID
AND ncp.License_Expiry IS NOT NULL
ORDER BY ncp.License_Expiry ASC

If someone would be able to help me, I'd really appreciate! Thanks a lot!

bourlis

Hi Alanaraki,

I think your problem is the 'and' statement where there should be 'where' statement.

Also, you may want to try using the status number than status description.

Lastly, you don't need a 'join' statement in this SWQL query. See below for an example, this is how I would do it in my environment.

SELECT 

n.Caption AS [System Name]

, n.CustomProperties.License_Product as [License Product]

, n.CustomProperties.License_Name  as [License Name]

, n.CustomProperties.License_Expiry as [License Expiration]

, n.CustomProperties.License_Owner as [License Owner]

, n.CustomProperties.License_Status as [License Status]


-- Icon mapping

, CASE

    when n.CustomProperties.License_Status = 'Active' then '1'

    when n.CustomProperties.License_Status = 'Renewal' then '2'

    when n.CustomProperties.License_Status = 'Expired' then '3' 

   ELSE '0'

  END AS [Status]


FROM Orion.Nodes n


where n.CustomProperties.License_Expiry IS NOT NULL


ORDER BY [License Expiration] ASC