# Transaction groups and UDTs

**URL:** <https://forum.inductiveautomation.com/t/transaction-groups-and-udts/33824>\
**Category:** Ignition\
**Created:** [April 9, 2020, 3:23pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-and-udts/33824 "2020-04-09T15:23:34Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![dkylep](https://avatars.discourse-cdn.com/v4/letter/d/6de8d8/32.png) [@dkylep](https://forum.inductiveautomation.com/u/dkylep)\
**Post date:** [April 10, 2020, 2:09pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-and-udts/33824/3 "2020-04-10T14:09:46Z")

</div>

Thanks for the input @scicco, you have me contemplating both of those options. I found another thread discussing dynamically creating transactions groups. I've been thinking my way through using a script to modify an XML template and using `system.groups.loadFromFile`. But, I haven't sold myself on this yet. Keeping track of when to add (possibly remove) transactions groups seems too complicated.

> [@Dynamically-Driven Transaction Groups In SQL Bridge?](http://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/11):
>
> No update. It’s still something we want to do, but it would be part of a more fundamental rewrite of SQLBridge/transaction groups, which is a significant undertaking; certainly don’t expect it in the next few months.

I think I'm leaning toward using the tag event script. My thought is to have a new 'update' tag that is on the PLC. If it is simply a bit that switches between a 1 and a 0 I could have tag event script run when the value changes from either 0 to 1 and/or 1 to 0. I'll just have to write the SQL statements myself which shouldn't be too big of deal.

---

_[View the full topic](https://forum.inductiveautomation.com/t/transaction-groups-and-udts/33824)._