If I can run a SWQL query in the SDK on our SW server, will the same query work in Modern Dashboards

John-AVUSD

I'm just starting out with SWQL and Modern Dashboards. I've watched the virtual classroom videos on the topic. I wanted to make sure that I could test and learn queries on the server and then just copy them to a user defined query while making a dashboard.  I suspect this should work. 

My observation so far is that I could really use a SWQL reference list to see what each query command does.  I can type the first letter of each command and see the list for that letter, but I need to know what they do. My SQL knowledge is pretty old, but I remember the concepts. I just keep getting errors in what I think should be simple queries. 

Ex: SELECT NodeName FROM Orion.Nodes
WHERE NodeName IS LIKE "NOC";

Just trying to see if I can find nodes whose names include those letters.  The error is " no variable alternative at input 'IS' in Where clause "

Seashore

Hi

You can learn more from these pages:  [mention:09c5a629069e46b189951199b458fa8f:6b577b8c04704e209d29b6772bf67243] 

In your example you should write:

SELECT 
    NodeName 
FROM Orion.Nodes
WHERE 
    NodeName LIKE '%NOC%'

Skip the "IS" and use ' instead of ". %-sign is the wildcard character.

Hope this helps