# Transaction Groups - After writing new line get id number back

**URL:** <https://forum.inductiveautomation.com/t/transaction-groups-after-writing-new-line-get-id-number-back/95417>\
**Category:** Ignition\
**Created:** [September 2, 2024, 5:35am UTC](https://forum.inductiveautomation.com/t/transaction-groups-after-writing-new-line-get-id-number-back/95417 "2024-09-02T05:35:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Kranjc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/david_kranjc/32/43007_2.png) [@David\_Kranjc](https://forum.inductiveautomation.com/u/David_Kranjc)\
**Post date:** [September 2, 2024, 5:35am UTC](https://forum.inductiveautomation.com/t/transaction-groups-after-writing-new-line-get-id-number-back/95417/1 "2024-09-02T05:35:33Z")

</div>

Hello,  
is it possible with Transaction Group after entering new measurements/data (new rows in the SQL table) to get back the "id" value of the row ("id" is a parameter that is automatically generated/increased when a new value is entered)? Similar like in query in the picture?  
Many thanks in advance for your replies,  
David

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/5/759c55acec2a3346129c1c43f79c5163885d3cd9.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 2, 2024, 8:31am UTC](https://forum.inductiveautomation.com/t/transaction-groups-after-writing-new-line-get-id-number-back/95417/2 "2024-09-02T08:31:09Z")

</div>

Have a look at the getKey parameter in [system.db.runNamedQuery | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runNamedQuery#parameters). I haven't tried it and don't know if it can be used with Transaction Group.

---

<div class="post-metadata">

**Author:** ![David\_Kranjc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/david_kranjc/32/43007_2.png) [@David\_Kranjc](https://forum.inductiveautomation.com/u/David_Kranjc)\
**Post date:** [September 2, 2024, 8:39am UTC](https://forum.inductiveautomation.com/t/transaction-groups-after-writing-new-line-get-id-number-back/95417/3 "2024-09-02T08:39:10Z")

</div>

Yes, that works. But I would like to get "id" back inside Transaction Group.

If I first write the data to the DB with the Transaction Group (Standard Group) and then immediately make a query for runNamesQuery, it happens that I don't get the last "id" value. It's like that Transaction Group wrote to the DB later (with a delay).

---

<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 2, 2024, 12:54pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-after-writing-new-line-get-id-number-back/95417/4 "2024-09-02T12:54:53Z")

</div>

Ignition uses DB connection pools, so the odds that a following, separate, query will use the same actual connection as the transaction group are very low. And retrieving the "last inserted ID" requires execution on the same actual DB connection.

You will need to switch to a script if this ID is critical to your application.

---

<div class="post-metadata">

**Author:** ![David\_Kranjc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/david_kranjc/32/43007_2.png) [@David\_Kranjc](https://forum.inductiveautomation.com/u/David_Kranjc)\
**Post date:** [September 3, 2024, 6:07am UTC](https://forum.inductiveautomation.com/t/transaction-groups-after-writing-new-line-get-id-number-back/95417/5 "2024-09-03T06:07:54Z")

</div>

Thank you very much for the information. I implemented solution this way.