Queries, Transaction Groups or something else?

Ignition
,
1

Hi all,
we have a machine with about 80 individual Positions; each position can belong to a larger logical area called a Zone.

I am attempting to record multiple datapoints per Position and per Zone on a button click event. Currently I have Transaction Groups ready for the Zone data, but as I look at the Positions, I am not so sure TGs are the way to go. The data tables store one row per Zone or per Position, which means I need one TG per Zone and one TG per Position. Which means like 100 TGs all firing from one trigger tag.

Does this seem like a good way to go about this? If there are better, more efficient ways, what are they?

thanks,
Mike

2

This should be scripted. You will probably also want to construct a multi-row prep insert to minimize the round trips to the database.