# Transaction Group Table Name Field, schema issue

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-table-name-field-schema-issue/95911>\
**Category:** Ignition\
**Created:** [September 12, 2024, 6:49pm UTC](https://forum.inductiveautomation.com/t/transaction-group-table-name-field-schema-issue/95911 "2024-09-12T18:49:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [September 12, 2024, 6:49pm UTC](https://forum.inductiveautomation.com/t/transaction-group-table-name-field-schema-issue/95911/1 "2024-09-12T18:49:28Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 12, 2024, 7:32pm UTC](https://forum.inductiveautomation.com/t/transaction-group-table-name-field-schema-issue/95911/2 "2024-09-12T19:32:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [September 12, 2024, 9:12pm UTC](https://forum.inductiveautomation.com/t/transaction-group-table-name-field-schema-issue/95911/3 "2024-09-12T21:12:40Z")

</div>

Perhaps this is worth submitting as a bug or feature?

---

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [September 12, 2024, 10:08pm UTC](https://forum.inductiveautomation.com/t/transaction-group-table-name-field-schema-issue/95911/4 "2024-09-12T22:08:52Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/9/29a2956fcbbab0b1d55ab7b5b0b67a9c5bdd5968.png)