Querytag using {

Ignition
1

Hi,

I am trying to use the following query in a query tag:

SELECT Count(*) FROM MESWorkOrder WHERE NAME NOT LIKE "%{%"

Ignition does not seem to accept the {. Is there a solution for this?

The query works exactly the same way in a named query.

Thank you very much for your help.

René

2

Do double curly braces work? If you're on 8.1.5 or later they're supposed to within general tag properties, though there's additional layers involved with the DB so it still might not.

That is,
SELECT Count(*) FROM MESWorkOrder WHERE NAME NOT LIKE "%{{%"
Should, in theory, emit to the DB as a single curly brace?

1 Like
3

No, same result, I think I’ll use a view in mysql to run this query and just call the view from ignition.

4

(post deleted by author)