# Querytag using {

**URL:** <https://forum.inductiveautomation.com/t/querytag-using/114343>\
**Category:** Ignition\
**Created:** [March 5, 2026, 4:15pm UTC](https://forum.inductiveautomation.com/t/querytag-using/114343 "2026-03-05T16:15:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rene\_Ries](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@Rene\_Ries](https://forum.inductiveautomation.com/u/Rene_Ries)\
**Post date:** [March 5, 2026, 4:15pm UTC](https://forum.inductiveautomation.com/t/querytag-using/114343/1 "2026-03-05T16:15:28Z")

</div>

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é

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 5, 2026, 4:22pm UTC](https://forum.inductiveautomation.com/t/querytag-using/114343/2 "2026-03-05T16:22:57Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Rene\_Ries](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@Rene\_Ries](https://forum.inductiveautomation.com/u/Rene_Ries)\
**Post date:** [March 5, 2026, 4:27pm UTC](https://forum.inductiveautomation.com/t/querytag-using/114343/3 "2026-03-05T16:27:16Z")

</div>

> [@paul-griffith](#):
>
> SELECT Count(\*) FROM MESWorkOrder WHERE NAME NOT LIKE "%{{%

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

---

<div class="post-metadata">

**Author:** ![Matthew\_Automation](https://avatars.discourse-cdn.com/v4/letter/m/a4c791/32.png) [@Matthew\_Automation](https://forum.inductiveautomation.com/u/Matthew_Automation)\
**Post date:** [March 5, 2026, 6:46pm UTC](https://forum.inductiveautomation.com/t/querytag-using/114343/5 "2026-03-05T18:46:02Z")

</div>

–Could you use a back-slash before the curly brace so itll be read as a literal?–

Edit: Ignore that. Realized Paul was right and the {{ should make it read as a literal.