Using Tags in a Dataset in UDT & SQL

Good Evening,

I have these tags that are used in a UDT. Is it possible to put them into a Dataset tag, and if so, how would I do it? And can you set a Dataset tag to SQL?

Thanks,
Ryan

Is your point of setting it to a dataset tag just to put it into a SQL Database?

Yes and no. There is 2 reasons, yes the first one is to put it into SQL and the second is to put it into a dataset so I can parse that active rows into a table that can be viewed on another screen.

Something like this:

I do realise there are many ways to do the same thing, so if SQL is easier, then I can do that. But what do you think?

I have successfully put tag addresses in database tables, then at runtime, read a list of tags of interest via system.opc.readValues to get data from the devices only when needed. That way, instead of constantly polling thousands of tags, only one or two tags need to be watched by Gateway Event Script(s), Tag Change that reads everything of interest only when needed.
For an on-screen display, use SQL to read the tag addresses and update the table with fresh values.
I use a 'pulse' expression tag that a view custom value can bind to with a one-line change script that calls a project library script to update the UI only when that view is active.
Some examples:

  • Show progress on a slow running process that takes more than a day to complete
  • Running status on lot of identical machines that are not all always running
  • Rare, unpredictable events that have hundreds of associated data points
1 Like