2 Replies Latest reply on Dec 13, 2013 3:00 AM by Jan Pelousek

    Help with SWQL query that needs to access a custom property

    ian.johnson@epicgames.com

      Hi,

       

      I have a SWQL query that is failing when trying to access a custom property in the Nodes table.

       

      Works fine:

       

      SELECT Caption

      FROM Orion.Nodes

      WHERE NodeID='990'

       

      Does not work:

       

      SELECT Node.CustomProperties.AlertRules

      FROM Orion.Nodes

      WHERE NodeID='990'


      Can someone help me with the syntax here and maybe some insight into why the Node.CustomProperties.CustomProperty doesn't seem to work?


      Thank you,


      Ian