Transaction Group Table Name Field, schema issue

Ignition
1

I've noticed that when I create a TG and select a table from the drop down list, that: IF the schema is different than dbo the selected table cannot be found when executing the TG.
Now, when I type in the schema name, such as production.table_1, then the table is "visible" by the TG, BUT, there are no fields available in the drop down boxes for each OPC/Group item to configure. I have to manually type the field/column name that I want that tag's value to be stored to.

Is there a fix for this? Thanks

2

No, transaction groups don't properly handle schemas--I think because they mishandle identifier quoting.

3

Perhaps this is worth submitting as a bug or feature?

4

It would be handy if the drop-down box for the DB target name filtered as you typed the name in.

image
image742×110 6.94 KB