Transaction Groups - SQL Select -> OPC

Can anyone provide guidance to or provide a good example of how to use SQL Select statements in Transaction Groups to pull data from SQL tables and write the results to OPC PLC tags?

Hi Steve, welcome to the forums! :slight_smile:

An initial example. The read expression items is are queries, the scale expression items massage the query result and send to a tag as a target instead of a database column.

This could be made more efficient by having one query (assuming everything you want is in one table) and using lookup expressions to extract items from the dataset.

Hope this helps!


Thanks for the example Jordan. I’m sure it will help.