# Transaction Group Table Action Custom Update

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-table-action-custom-update/9642>\
**Category:** Ignition\
**Created:** [February 2, 2015, 10:52pm UTC](https://forum.inductiveautomation.com/t/transaction-group-table-action-custom-update/9642 "2015-02-02T22:52:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MCC](https://avatars.discourse-cdn.com/v4/letter/m/3e96dc/32.png) [@MCC](https://forum.inductiveautomation.com/u/MCC)\
**Post date:** [February 2, 2015, 10:52pm UTC](https://forum.inductiveautomation.com/t/transaction-group-table-action-custom-update/9642/1 "2015-02-02T22:52:04Z")

</div>

What is the syntax for the custom update/select section of a standard transaction group? Do you enter a WHERE clause? Can it be complicated? One example is I would like to update the most recent row in a table that matches a criterion. There may be several rows in the table that match the criterion, but I want to update the most recent (as measured by a tstamp or by the primary key).

---

<div class="post-metadata">

**Author:** ![richardNZ15](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/richardnz15/32/33373_2.png) [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\
**Post date:** [November 18, 2016, 1:45am UTC](https://forum.inductiveautomation.com/t/transaction-group-table-action-custom-update/9642/2 "2016-11-18T01:45:45Z")

</div>

Bump. Also trying to figure out how to use custom update query for block transaction groups.  
Pretty poor documentation on it