# Dynamically-Driven Transaction Groups In SQL Bridge? **URL:** \ **Category:** Ignition\ **Created:** [January 22, 2019, 4:42pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047 "2019-01-22T16:42:57Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![bart\_noble](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bart_noble/32/7399_2.png) [@bart\_noble](https://forum.inductiveautomation.com/u/bart_noble)\ **Post date:** [January 22, 2019, 4:42pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/1 "2019-01-22T16:42:57Z")
Looking for ideas or an example of how to create/remove/modify transaction groups dynamically in SQL Bridge. ---
**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:** [January 22, 2019, 4:45pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/2 "2019-01-22T16:45:10Z")
Do you absolutely have to do them at runtime? If you simply have a whole bunch of similar groups to create, you can export one as XML, convert it to a template with PHP or your favorite scripting language, and import many back in. ---
**Author:** ![bart\_noble](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bart_noble/32/7399_2.png) [@bart\_noble](https://forum.inductiveautomation.com/u/bart_noble)\ **Post date:** [January 22, 2019, 5:54pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/3 "2019-01-22T17:54:05Z")
Runtime isn’t a necessity and we could surely do it with another programming language but I was hoping there might be something we code in Ignition itself to bridge (for lack of a better word) to the SQL Bridge module (e.g. scan specific tags and modify SQL Bridge using Ignition scripts). ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 22, 2019, 6:02pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/4 "2019-01-22T18:02:11Z")
Short answer: no. There is `system.groups.loadFromFile`, but 1. it requires building the entire XML structure from scratch (or having a premade template) and 2. there’s no mechanism for deleting groups. In 8.0, you’ll be able to somewhat accomplish this, by simply deleting and creating resources directly on the filesystem, but we do have plans for more first-class, “dynamic” transaction group support in the future. ---
**Author:** ![bart\_noble](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bart_noble/32/7399_2.png) [@bart\_noble](https://forum.inductiveautomation.com/u/bart_noble)\ **Post date:** [January 22, 2019, 6:12pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/5 "2019-01-22T18:12:36Z")
This is good information. Thank you. It would be really helpful to see this functionality in version 8. Having to manually do this in SQL Bridge would be impossible for us. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 22, 2019, 8:03pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/6 "2019-01-22T20:03:00Z")
> [@paul-griffith](#): > > 1. there’s no mechanism for deleting groups. Quick correction on this, as one of my colleagues pointed out, you can use `system.groups.removeGroups` to achieve this. Not sure what my brain was thinking of when I said that. ---
**Author:** ![bart\_noble](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bart_noble/32/7399_2.png) [@bart\_noble](https://forum.inductiveautomation.com/u/bart_noble)\ **Post date:** [January 22, 2019, 9:16pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/7 "2019-01-22T21:16:16Z")
Okay, that’s interesting and might help us in the short-term. Thanks again. ---
**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:** [January 22, 2019, 9:53pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/8 "2019-01-22T21:53:20Z")
> [@paul-griffith](#): > > you can use `system.groups.removeGroups` to achieve this Yeah, but how do you know what you need to delete? /-: ---
**Author:** ![bart\_noble](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bart_noble/32/7399_2.png) [@bart\_noble](https://forum.inductiveautomation.com/u/bart_noble)\ **Post date:** [January 22, 2019, 9:54pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/9 "2019-01-22T21:54:48Z")
I don’t suspect I would but I was considering just removing all and rewriting all as needed. ---
**Author:** ![dkylep](https://avatars.discourse-cdn.com/v4/letter/d/6de8d8/32.png) [@dkylep](https://forum.inductiveautomation.com/u/dkylep)\ **Post date:** [April 9, 2020, 6:03pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/10 "2020-04-09T18:03:05Z")
> [@paul-griffith](#): > > we do have plans for more first-class, “dynamic” transaction group support in the future Is there any update on this?? My project is young and I'd like to use what is/may be available. I'll have multiple PLC completing the same tasks and I would love to create a single transaction group for the 10 PLCs I have now and use the same transaction group for the 50 PLCs I'll have later. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [April 9, 2020, 6:08pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/11 "2020-04-09T18:08:22Z")
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. ---
**Author:** ![bradley.falzon](https://avatars.discourse-cdn.com/v4/letter/b/e495f1/32.png) [@bradley.falzon](https://forum.inductiveautomation.com/u/bradley.falzon)\ **Post date:** [February 11, 2021, 10:52pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/12 "2021-02-11T22:52:05Z")
I just want to +1 this functionality as well, in particular, because we’re having a few tags generated dynamically from various sensors and trying to minimise the amount of work required to configure each sensor. Having the ability to have a new kind of “parameterised” item, which executes the transaction group for every tag it matches would be ideal. For example “gateway/{sensor\_id}/event/up/rxInfo/rssi” and being able to then insert the rssi into the database along with extracting the sensor\_id to also insert would be 👌 ---
**Author:** ![Braxton\_McKean](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@Braxton\_McKean](https://forum.inductiveautomation.com/u/Braxton_McKean)\ **Post date:** [April 6, 2022, 5:10pm UTC](https://forum.inductiveautomation.com/t/dynamically-driven-transaction-groups-in-sql-bridge/22047/13 "2022-04-06T17:10:36Z")
I also want to +1 this feature. I’m working on a project where we have OEELine UDTs that are backed by a database. In order to record values/events to the database we have a separate transaction group for each UDT instance. Being able to add a transaction group to a UDT or creating a parameterized TG that can accept a UDT would save a lot of time and headache.