Rescource Report from Orion Report Writer Filter on Node

Question

HI,

How would I go about filtering a Orion Report Writer Rescource based on the node I am viewing the report in question is an Advance SQL Report I have tried nodeid = ${NodeId} in the filter but this doesn't seem to work, any ideas?

clefranc · Answer

Ok, I got it!!!

clefranc · Answer

Hi Rhidian,

Can you be a little more specific? Same problem here, the Filter Nodes (SQL) in edit resource doesn't work with my Advance SQL report.

Thanks

Christian

FormerMember · Answer

Job done I have added a wher eclause to the SQL and it works like a charm so Nodes.NodeID  = ${NodeID} then boom...