# Reverse of Triggered Transaction Group? Pulls a Record from DB Table and Populates UDT

**URL:** <https://forum.inductiveautomation.com/t/reverse-of-triggered-transaction-group-pulls-a-record-from-db-table-and-populates-udt/17021>\
**Category:** Ignition\
**Created:** [February 16, 2018, 9:08pm UTC](https://forum.inductiveautomation.com/t/reverse-of-triggered-transaction-group-pulls-a-record-from-db-table-and-populates-udt/17021 "2018-02-16T21:08:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dano38291](https://avatars.discourse-cdn.com/v4/letter/d/9d8465/32.png) [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\
**Post date:** [February 16, 2018, 9:08pm UTC](https://forum.inductiveautomation.com/t/reverse-of-triggered-transaction-group-pulls-a-record-from-db-table-and-populates-udt/17021/1 "2018-02-16T21:08:31Z")

</div>

Hello,  
I am storing Tags of a UDT to my DB using a Triggered Transaction group. This was a pretty painless process to store the data. I just had to drag the Tags into Group Items and I had to create a Trigger On Item tag.

Is there an easy was to do the Reverse of this Process. What is the recommended way to pull a record/row out of the DB table and map the Columns of the DB table back to Tags in my UDT.

---

<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:** [February 16, 2018, 9:18pm UTC](https://forum.inductiveautomation.com/t/reverse-of-triggered-transaction-group-pulls-a-record-from-db-table-and-populates-udt/17021/2 "2018-02-16T21:18:20Z")

</div>

Transaction groups can go either way. The caveat is how you select the row you pull back out.

---

<div class="post-metadata">

**Author:** ![dano38291](https://avatars.discourse-cdn.com/v4/letter/d/9d8465/32.png) [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\
**Post date:** [February 19, 2018, 2:00pm UTC](https://forum.inductiveautomation.com/t/reverse-of-triggered-transaction-group-pulls-a-record-from-db-table-and-populates-udt/17021/3 "2018-02-19T14:00:06Z")

</div>

Thanks for the TIp! I dug in some more and found a video on Updating or Inserting a New row. Its nice that a lot of the code for updating and querying the database is already created. The Recipe Video was helpful as well  
[https://inductiveuniversity.com/video/update-or-insert-group?r=/course/transaction-groups](https://inductiveuniversity.com/video/update-or-insert-group?r=/course/transaction-groups)