I seem to be having a lot of issues with API swql queries after updating to version 2020.2. I can't seem to make heads or tails of this yet, but it seem like there is some issue with the API interpretation of the WHERE clause.
For example this query works:
SELECT n.Caption, n.MachineType
FROM Orion.Nodes n
WHERE
n.Caption LIKE 'colm*' OR
n.Caption LIKE 'colh*'
and this one will work too:
SELECT n.Caption, n.MachineType
FROM Orion.Nodes n
WHERE
n.Caption LIKE 'colm*' OR
n.Caption LIKE 'stlgic*'
But this one does not:
SELECT n.Caption, n.MachineType
FROM Orion.Nodes n
WHERE
n.Caption LIKE 'colm*' OR
n.Caption LIKE 'colh*' OR
n.Caption LIKE 'stlgic*'
Sub out the * with percent symbol.
It's like it's not working for the third condition, but some of the more complex queries I have built work fine. Is anyone else having these issues?