# Transaction Group direction

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-direction/75611>\
**Category:** Ignition\
**Created:** [June 27, 2023, 9:24pm UTC](https://forum.inductiveautomation.com/t/transaction-group-direction/75611 "2023-06-27T21:24:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![eddie\_johnson](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@eddie\_johnson](https://forum.inductiveautomation.com/u/eddie_johnson)\
**Post date:** [June 27, 2023, 9:24pm UTC](https://forum.inductiveautomation.com/t/transaction-group-direction/75611/1 "2023-06-27T21:24:47Z")

</div>

Is the Transaction Group capable of reading from the SQL DB and writing to tags? No matter the mode I select it seemed to try writing to the DB.

---

<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:** [June 27, 2023, 9:27pm UTC](https://forum.inductiveautomation.com/t/transaction-group-direction/75611/2 "2023-06-27T21:27:37Z")

</div>

Yes, with the direction setting **per item**. But note that you will almost certainly need a `WHERE` clause to get the right row from the DB.

---

<div class="post-metadata">

**Author:** ![eddie\_johnson](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@eddie\_johnson](https://forum.inductiveautomation.com/u/eddie_johnson)\
**Post date:** [June 27, 2023, 9:32pm UTC](https://forum.inductiveautomation.com/t/transaction-group-direction/75611/3 "2023-06-27T21:32:33Z")

</div>

I'm imssing any query, I'm sure that's it, thanks.
