This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Report Designer - Advanced SQL - Node Custom Properties

When using Advanced SQL in Report Designer, how do we pull through the Node Custom Properties?

I've searched high and low, a couple of similar unanswered questions so still getting a SQL Error when trying to use the names of the Custom Properties.

  • If you are actually using SQL and not SWQL then the name of the property is the name of the column and it is just on the Nodes view, no need to pull anything in at all.

    In SWQL you need to navigate from orion.nodes to nodes.customproperties.[yourpropertyhere]