# Transaction Group Row ID

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-row-id/8560>\
**Category:** Ignition\
**Created:** [June 12, 2014, 9:31pm UTC](https://forum.inductiveautomation.com/t/transaction-group-row-id/8560 "2014-06-12T21:31:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rdeavers](https://avatars.discourse-cdn.com/v4/letter/r/779978/32.png) [@rdeavers](https://forum.inductiveautomation.com/u/rdeavers)\
**Post date:** [June 12, 2014, 9:31pm UTC](https://forum.inductiveautomation.com/t/transaction-group-row-id/8560/1 "2014-06-12T21:31:22Z")

</div>

I want to get the id of the row inserted into a database by a transaction group. Is this possible?

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [June 13, 2014, 10:51pm UTC](https://forum.inductiveautomation.com/t/transaction-group-row-id/8560/2 "2014-06-13T22:51:58Z")

</div>

Is the data going into a table where data is being inserted by the transaction group and by some other means?

---

<div class="post-metadata">

**Author:** ![rdeavers](https://avatars.discourse-cdn.com/v4/letter/r/779978/32.png) [@rdeavers](https://forum.inductiveautomation.com/u/rdeavers)\
**Post date:** [June 13, 2014, 11:11pm UTC](https://forum.inductiveautomation.com/t/transaction-group-row-id/8560/3 "2014-06-13T23:11:32Z")

</div>

There is multiple transaction groups inserting data into this table. Every hour, each area (currently three) with their own transaction group, inserts one row into this table.

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [June 16, 2014, 9:23pm UTC](https://forum.inductiveautomation.com/t/transaction-group-row-id/8560/4 "2014-06-16T21:23:33Z")

</div>

You could try adding a column to the table and then pushing in the Transaction Group Name (or whatever you want) when the transaction group executes.

---

<div class="post-metadata">

**Author:** ![rdeavers](https://avatars.discourse-cdn.com/v4/letter/r/779978/32.png) [@rdeavers](https://forum.inductiveautomation.com/u/rdeavers)\
**Post date:** [June 16, 2014, 9:31pm UTC](https://forum.inductiveautomation.com/t/transaction-group-row-id/8560/5 "2014-06-16T21:31:42Z")

</div>

I understand that will give me the option of selecting rows by transaction group but I want to get the index number generated by the insert command. I know this can be done with a script but I was wondering if I could do it within a transaction group.

---

<div class="post-metadata">

**Author:** ![TimOSullivan](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@TimOSullivan](https://forum.inductiveautomation.com/u/TimOSullivan)\
**Post date:** [July 9, 2014, 2:27pm UTC](https://forum.inductiveautomation.com/t/transaction-group-row-id/8560/6 "2014-07-09T14:27:29Z")

</div>

I’ve the same requirement.  
Did you get any method to do this?

tim