Using "Current Node" in the SQL Filter of a Widget

schugs

Hey Everyone!

I am looking to add a widget to the Node Details - Summary view that would show all other nodes with the same Custom property.  Essentially i have a custom property, "SiteCode", that groups my nodes based on their location.  When looking at the details of one of these nodes, i'd like to see the list of all other nodes at that site also.

I have tried using the "All Nodes" widget, then filtering it based on site code.  I can get it to work if i hard code the site code value, but this then is static and doesn't change if i'm looking at a different sites node.

Filters I've Tried:

SiteCode='LVG'  -- Works at only showing LVG nodes, but obviously doesnt change if im looking at a node say for CHA site.

SiteCode=${SiteCode}  -  SQL Pares Error

SiteCode='${SiteCode}' - No results

schugs

Ultimately I got what i needed by using a "Custom Table" Widget with a custom data source using "Advance Database Query (SQL,SWQL)" and the below select statement.  You can then use the "Caption" field and Display settings to give the status, link, and hover tooltip.

Select Statement

SELECT NodeID, Caption, IPAddress, Status, ChildStatus, DetailsUrl

FROM Orion.Nodes

WHERE Nodes.CustomProperties.SiteCode = ${SiteCode}