# Transaction Group Update key/value pair -- never matches

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-update-key-value-pair-never-matches/28446>\
**Category:** Ignition\
**Tags:** ignition80, database\
**Created:** [September 20, 2019, 8:55pm UTC](https://forum.inductiveautomation.com/t/transaction-group-update-key-value-pair-never-matches/28446 "2019-09-20T20:55:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![paul.bouillon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.bouillon/32/7980_2.png) [@paul.bouillon](https://forum.inductiveautomation.com/u/paul.bouillon)\
**Post date:** [September 20, 2019, 8:55pm UTC](https://forum.inductiveautomation.com/t/transaction-group-update-key-value-pair-never-matches/28446/1 "2019-09-20T20:55:02Z")

</div>

Hello,

I’m running into some issues with my transaction groups – they had been functioning as expected (v8.0.0-\>8.0.3), until moving the group to a new gateway (v8.0.3)… weird!

Essentially I am looking to log “delay” events into a DB, after a device’s speed has been at 0 for a predetermined amount of time…  
The idea is to do “update” queries for my “end\_ts” (with value of “now()”) while my trigger is active (update while matching the start\_ts – which is the last timestamp of the “skipping” tag.

 ![tg_skip_delay](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/7334bb0144e0abd545209f02584e08d24d2e2679.png)

- 0000L/Hoist/Skipping = a boolean tag (evaluates as true when the device speed is above a predefined threshold)
- 0000L/Hoist/Skipping\_Timestamp = a datetime tag that holds the timestamp/last change time of the tag mentioned above
- 0000L/Hoist/Skipping\_off\_seconds = an hour meter tag that counts the seconds that “skipping” has been off
- 0000L/Hoist/Skip\_Stopped\_Delay\_Seconds = an integer (memory) tag that defines the seconds threshold for when a delay event should be triggered (see trigger def below)

I’ve got my trigger defined as:

 ![tg_sd_trigger](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c58927104d8ba575b48e0d3113c042406fc2c47f.png)

And my SQL server automatically enters the id (sequential uniqueid/uuid) on insert.

Ideally I would match against the “id” that is returned on the insert operation… but don’t think that is possible with transaction groups, the way they currently function…

Once i moved this transaction group to a new ignition gateway – it started inserting new rows every second! (e.g. as if the match key/value pair was not working any longer)…

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/554a778a7d1af73d146f9943385995c968af647f.jpeg)

Has anyone experienced anything similar/have any ideas on how to best approach a solution?

Any ideas/thoughts would be greatly appreciated.

Thanks!

-Paul