# Event driven query tags null

**URL:** <https://forum.inductiveautomation.com/t/event-driven-query-tags-null/80441>\
**Category:** Ignition\
**Created:** [October 13, 2023, 12:49pm UTC](https://forum.inductiveautomation.com/t/event-driven-query-tags-null/80441 "2023-10-13T12:49:15Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Zach\_Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zach_larson/32/54388_2.png) [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\
**Post date:** [April 1, 2024, 6:09pm UTC](https://forum.inductiveautomation.com/t/event-driven-query-tags-null/80441/9 "2024-04-01T18:09:36Z")

</div>

I am trying to do this sort of thing again.

The query tag value when set to sting type shows 1.

The query tag value set as a data type shows value as the column name.  
There is a 1 in the value for that column.

I get an error if I try to use 'as name' in the select.

```auto
select top 1 {[.]partString
from mytable t1
left join secondTable t2 on 
t1.line=t2.line
where part like concat('%','1b2345', '%')
and location ='B1'

```

I think the issue is that the string for partString starts with a number.

* * *

PTurmel saved me again.  
I needed to add quote marks.

> [@Query tag to alleviate some query workloads on perspective pages](https://forum.inductiveautomation.com/t/query-tag-to-alleviate-some-query-workloads-on-perspective-pages/59302/10):
>
> '{[~]Shifts/Current Shift Start}' \> '2022-01-25 07:00:00' But, still might not work because the date/time will be formatted using java's style. Consider not using a query tag. Use a memory tag, and use a gateway tag change event on shift start to run a PrepQuery. That can use ? substitution to avoid string conversion. Write the result dataset to the memory tag.

```auto
select top 1 '{[.]partString'
from mytable t1
left join secondTable t2 on 
t1.line=t2.line
where part like concat('%','1b2345', '%')
and location ='B1'

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/event-driven-query-tags-null/80441)._