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

    SWQL Wild Card

    map3696

      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:

       

      SELECT

      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.