I have a named query in Ignition 8 like the following:
SELECT TagId FROM sn_tags_and_items where DomainId = :domainId and TagPath like :tagPath
where I pass domainId=99 and a tagPath=/my/tag/path
the query works correctly in Authoring/Testing window of the Named Query tool but as soon as I bind it to some page I am returned in the binding preview with a:
Error_Configuration(“RuntimeException: Syntax Error on token: 'DIVIDE (Line 1, char 7)”)
notice I have no DIVIDE in my query so I don’t know where DIVIDE comes from, probably behind the lines some Ignition 8 escaping is involved.