Event driven query tags null

[Zach_Larson]

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.

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

'{[~]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.

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