6 Replies Latest reply on Jul 4, 2016 2:10 AM by Jan Pelousek

    SWQL Wild Card


      I am trying to create a query in SWQL Studio that only selects nodes with the caption of 'AMX-VZB-' and then something different after that. Ex only want AMX-VZB-1, AMX-VZB-2, AMX-VZB-3, AMX-VZB-4, etc. I want to do something similar to a % in SQL. Any suggestions? 

      This is my query:



      NODE.ID as NODEID,

      NODE.Caption AS NODE,

      FROM Orion.Nodes NODE

      ORDER BY NODE.Caption


      I want to include a where statement that is dynamic so that if nodes are added or taken away as long as they have that first part of the string they will be included in the query.