MySQL Function call within Query Tag

Ignition
1

I’d like to call a MySQL Function within the select statement of a Query Tag. The function returns a single value.

The syntax below doesn’t work:
select f2HrAvg({[.]PrevPrd/DayYear},‘10’);
The value in the brackets is a ind. auto tag.

It does work if I hard code the values as shown below:
select f2HrAvg(‘2012005’,‘10’);

Any help would be appreciated.

2

The only thing I can see is you use quotes in your hard-coded example. Maybe do the same thing with your dynamic one:select f2HrAvg('{[.]PrevPrd/DayYear}','10')You can right click on the tag and select “Tag Diagnostics” to see the error message.