Trying to use a nested variable.
I have defined a NodeId variable;
SELECT Caption as text, NodeID as value FROM Orion.Nodes
this works as expected.
However when I try to define an InterfaceID variable as below;-
SELECT Caption as text, InterfaceID as value FROM Orion.NPM.Interfaces where NodeID = ($NodeId)
$NodeId is not getting interpolated and just being passed as '($NodeId)' in the query rather than the value of $NodeId.
Trying to use a nested variable. I have defined a NodeId variable; SELECT Caption as text, NodeID as value FROM Orion.Nodes this works as expected.
However when I try to define an InterfaceID variable as below;- SELECT Caption as text, InterfaceID as value FROM Orion.NPM.Interfaces where NodeID = ($NodeId)
$NodeId is not getting interpolated and just being passed as '($NodeId)' in the query rather than the value of $NodeId.