I have a transaction group that will track the total gallons used when a counter tag counts up. I seen some anomalies in my data so I looked at the database and I have values that are doubling up. Do i have something setup wrong in my Transaction Group to allow the data to be loaded when the tag values has not changed?
As you can see the Ignition Tag is remaining the same but the data is getting tracked to SQL
My settings
The quality is probably changing.
Can I set it up so it only triggers on the value change?
Uncheck Only evaluate when values have changed,
Choose Execute this group on a trigger,
Select the tag you want to monitor,
Choose Active on value change for the Trigger conditions.
I am wondering if creating a named query and just putting all this on a Gateway Tag Change Script would be better. I can chose what it triggers on, plus I discovered when I make a change to my Transaction Group and save it, it writes one line to SQL doubling up my data. I can use the if not initialChange to prevent that.
Transaction Groups have an option "prevent trigger caused by group start" that should do the same thing as if not initialChange.
The scripting option should work just as well, so it is really up to you.
Thanks, I did not know that. I am fairly new to Transaction Groups and I like how powerful they are, I just have an easier time wrapping my head around the scripting route.
I need to put some time into understanding Transaction Groups a little better.
