Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Filtering on ${Value}

Hi Everyone,

Got a quick question, I am trying to setup a Node Tree on the Node detail page, with it filtered by a custom field, so that it only lists the nodes that are on that site.

I have tried using Sitename = ${Sitename} but that doesn't work. I know ${Sitename} returns the value that I want as it shows in the title of the Widget. and if I type in Sitename = 'The sitename' it works...

Find more posts tagged with

Accepted answers

KMSigma.SWI

Oh... OH! I see what you are saying.

You are on a Node Details page and you want to find all other devices that have one of its custom properties matching.

I don't think you are going to get any luck with that. Very much an edge case. But you can do it with a custom SWQL query.

All comments

KMSigma.SWI

For the filter, you'd just use the bare name of the custom property.

The All Nodes Tree resource is old and hasn't been changed to support the newer features of the platform, therefore it behaves slightly differently.

LeBeauUK

Hi @KMSigma.SWI ,

Is there any widget that will support the passing of a ${CUSTOM PROPERTY} parameter which will allow me to create a list of devices that are on the same site as the node they are looking at? As one of the request from my users is to allow faster navigation to devices.

KMSigma.SWI

Oh... OH! I see what you are saying.

You are on a Node Details page and you want to find all other devices that have one of its custom properties matching.

I don't think you are going to get any luck with that. Very much an edge case. But you can do it with a custom SWQL query.

LeBeauUK

Thanks for the pointer managed to get a list of device that are on that site, although I needed to use Like rather than = in the query:

select n.caption as [Device]
-- shows the current status icon
, '/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Device]
-- makes a clickable link to the node details
, n.DetailsUrl as [_linkfor_Device]
, n.CustomProperties.Model

from orion.nodes as n
where n.CustomProperties.SiteName like '%${SiteName}%'