Hi Forum, Given two tags tag1, tag2, and a workorder. On the production floor, when a process is running (indicated by a running tag). Every time tag1 value change, ignition needs to write both tag1 and tag2 values onto a database table including workorder. Such that, user could query these data…

I would use a transaction group to do this, with the trigger condition being the tag1 changing value

As Jasmine mentioned, this is where a transaction group (SQL Bridge) would work well, especially if you haven't done this type of thing before.

Is it a good practice to only log Tag Values with Good Quality? Should I log the value with quality along with it?

I would suggest that a tag with bad quality is junk data and should be left out of the database.

If you're not already using transaction groups, I'm not sure this use case justifies adding an extra module. If you need to use this pattern for a lot of tags, then maybe, and even then with a properly constructed tag hierarchy, transaction groups are not that helpful.. You can just use a gateway t…

[image] pascal.fragnoud: You can just use a gateway tag change event, I agree with you, since I know python and writing query, I find that transaction group also do the same thing under the hood. And it give me more flexibility using python. I will also take this opportunity to look at trans…

I come to conclude that, using transaction group will provide many benefits. I need help though. I watch all the videos, but still confuse how to configure transaction group according to client requirement: Below are the items: isRunning tag distance tag (int) workorder tag (string) val_1 val_2 …

Try this (I Haven’t tested it): [image] [image] [image] Trigger – On Value Change Video at Inductive University Learn how to configure a Transaction Group to only trigger when a value has changed, using either the Timer or Schedule option of the Execution Scheduling setting. …

[image] Eugene49: What if Execution timer is slower than distance tag increment? Set your execution time to the same rate as what you are polling the distance tag.

[image] Matrix_Engineering: This video and the next one are the ones you want. Thanks, i will try. I got confused on "Run Always Expression and Trigger Expression" vs the trigger tab. I guess just a matter of getting familiar. Edit: I now got clear on my confusion. On item table: Run Alw…

Inductive Automation Forum

Log tag values to database table

Ignition

Eugene49 November 8, 2025, 9:56pm 13

Thanks.
I got it.