This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Some sqwl queries stop working after upgrade to 2020.2

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?