Can somebody please tell why in the world this query tag isn’t working? I’m stumped. SELECT quantity FROM mill_workorders WHERE po = {[.]ReportPO} and style = {[.]ReportStyle} Error evaluating tag: Unknown column '0731514KP' in 'where clause' the 0731514KP is the tag value for ReportStyle, which …

Try: SELECT quantity FROM mill_workorders WHERE po = {[.]ReportPO} and style = '{[.]ReportStyle}' Query tags fill in values directly, before sending the query to the DB, so your statement is getting sent to the database as: SELECT quantity FROM mill_workorders WHERE po = 12345 and style = 0731514…

I thought about that, but I figured it would try to match it as literally “{[.]ReportStyle}” instead of the tag value, but I guess that’s what the {} are for. Thanks

Inductive Automation Forum

Query Tag Error

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled