SWQL Syntax: List of SWQL (NOT SQL) Arithmetic Operators, Keywords and Logic Operators

Question

I've been googling the past hour and looking for a list of operators (arithmetic and logic) and all the keywords used to construct SWQL filters and queries. 
 So far I've found six or so different resources that give about ten examples of the "=" operator and ten examples of the "LIKE" operator which does not seem to be a comprehensive guide . 
 Wildcards were mentioned but it doesn't say if you can use more than one in your query --> somevariable LIKE '%foo%' matching 'myfoobar' and 'foobar' 
 Is that it? Is that all there is? What about "NOT LIKE", which is what I'm really after in the immediate sense? Is there an equivalent? The resources I found also mention that it's a read only "subset" of SQL, (I am assuming they mean MSSQL) but there isn't any real definition of what that subset actually is. 
 Is there a resource available somewhere that I can find this information?

shuth · Accepted Answer

You need to use the following as the resource doesn't know whether you are looking at Node or Interfaces caption. Also take note that some of the widgets used SWQL and some use SQL filters to the syntax may change. 
 Interfaces.Caption NOT LIKE '%Tunnel%' 
 If you wanted to filter by node caption you would use: 
 Nodes.Caption NOT LIKE '%SW45%' 
 The SWQL/SQL format also changes how you reference custom properties: 
 SQL: Interfaces.Comments = 'Blah' 
 SWQL: Interfaces.CustomProperties.Comments = 'Blah'

mesverrum · Answer

We have this documentation of functions, https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions, but never seen any for the operators. As far as I can tell it supports everything you can do in SQL server. 
 
 https://www.w3schools.com/sql/sql_wildcards.asp although I admin I have never tried the bracket stuff, but I use % and _ in a million ways every day. Like, not like, in, between, etc. 
 
 I also just realized a good way to validate a syntax is just to run SWQL studio as it's syntax suggestions seem to contain all available functions as well. 
 https://github.com/solarwinds/OrionSDK/releases In hindsight I probably learned all the quirks of SWQL that I know from trying things out in there.

Chris-S · Answer

Thanks mesverrum... I did try the "NOT LIKE" logic in my SWQL statement but for some reason it didn't like it. I simply assumed it wasn't available, which appears to be my mistake. I'll try again this morning and get back to you.

SWQL Syntax: List of SWQL (NOT SQL) Arithmetic Operators, Keywords and Logic Operators

Top Replies