# Transaction Group Handshake Meaning **URL:** \ **Category:** Ignition\ **Created:** [June 11, 2021, 7:34pm UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716 "2021-06-11T19:34:55Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![sydney.bergeron](https://avatars.discourse-cdn.com/v4/letter/s/779978/32.png) [@sydney.bergeron](https://forum.inductiveautomation.com/u/sydney.bergeron)\ **Post date:** [June 11, 2021, 7:34pm UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/1 "2021-06-11T19:34:55Z")
What, specifically, do the “success” and “failure” handshakes mean in a transaction group? And are they configurable? I’ve got a transaction group I’m using to return a string value based on a code I give it. So it’s using a select query and finding the message associated with the given code in a SQL table. When I give it a code that doesn’t exist in the table, the handshake returns success but doesn’t write any value to my string tag. This is not ideal behavior, as I’d at least want it to return an empty string. And if not, to return a failure handshake. I can always write this in script form with a named query, but it would be nice to use the transaction group. ---
**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 11, 2021, 7:45pm UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/2 "2021-06-11T19:45:53Z")
They are basically success or failure of the query. A SELECT returning no rows isn’t an error. /: I use a script when I need real handshaking. ---
**Author:** ![sydney.bergeron](https://avatars.discourse-cdn.com/v4/letter/s/779978/32.png) [@sydney.bergeron](https://forum.inductiveautomation.com/u/sydney.bergeron)\ **Post date:** [June 11, 2021, 7:52pm UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/3 "2021-06-11T19:52:14Z")
I agree that it’s not an error but I’d argue that it is a failure. It sounds like I can’t change the failure criteria of a transaction group, though. But since it’s not considered a failure, I am surprised that a select query that returns empty doesn’t at least write an empty string/zero/null values to the tags that I have linked to columns. ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [June 11, 2021, 8:06pm UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/4 "2021-06-11T20:06:32Z")
Isn’t there an option for writing nulls? Not at computer to verify. ---
**Author:** ![sydney.bergeron](https://avatars.discourse-cdn.com/v4/letter/s/779978/32.png) [@sydney.bergeron](https://forum.inductiveautomation.com/u/sydney.bergeron)\ **Post date:** [June 11, 2021, 8:19pm UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/5 "2021-06-11T20:19:28Z")
Set NULL DB values to default, yes. It didn’t seem to work for us. I’m not sure if it technically returns null or just an empty table. ---
**Author:** ![wschauer](https://avatars.discourse-cdn.com/v4/letter/w/ecccb3/32.png) [@wschauer](https://forum.inductiveautomation.com/u/wschauer)\ **Post date:** [July 21, 2021, 12:30am UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/6 "2021-07-21T00:30:46Z")
Try disabling the store and forward system for the group. ---
**Author:** ![Michael\_Crane](https://avatars.discourse-cdn.com/v4/letter/m/8dc957/32.png) [@Michael\_Crane](https://forum.inductiveautomation.com/u/Michael_Crane)\ **Post date:** [August 16, 2022, 5:13pm UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/7 "2022-08-16T17:13:55Z")
Has this been solved? Im having the same issue. Id like to receive some notice if the transaction does not find corelating data in the database. ---
**Author:** ![Michael\_Crane](https://avatars.discourse-cdn.com/v4/letter/m/8dc957/32.png) [@Michael\_Crane](https://forum.inductiveautomation.com/u/Michael_Crane)\ **Post date:** [August 16, 2022, 8:20pm UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/8 "2022-08-16T20:20:15Z")
i added a sgl query as a triggered expression to the Transaction Group. I counted the database for the recipe number. if its there is shows a 1. if its not there it shows a 0. same as a handshake that tells me if the recipe is there or not. SELECT COUNT(Column) FROM TableName WHERE Column = ‘RecipeNumber’ ---
**Author:** ![jorge.galvez](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@jorge.galvez](https://forum.inductiveautomation.com/u/jorge.galvez)\ **Post date:** [November 15, 2024, 12:42am UTC](https://forum.inductiveautomation.com/t/transaction-group-handshake-meaning/47716/9 "2024-11-15T00:42:47Z")
This worked for me.