How to get the digital state from PI using Teiid?

[thiru28]

How to get the digital state from PI using Teiid?

Below query was working fine in OLEDB tester, but Teiid is not working

SELECT tag, time, value, DIGSTRING(status)

FROM [piarchive]..[picomp2]

WHERE tag = 'ba:active.1'

Please tell me the steps.

[shawkins]

Isn't this just a reposting of How to create pushdown function for DIGSTRING using ("teiid_rel:native-query" '$1') in VDB ddl xml file?

Or is there something new/else you are experiencing?