SQL query tag addressing

Ignition
1

I have some SQL query tags, I store the result as Dataset, the I use them in the Vision Windows as in the image below (dataset address).

Is this the "right" recommended way to use them or should assign the dataset individual addresses to individual specific Memory tags then use them? as example if I read in the Dataset many machine names then assign each of them to an individual memory tag? thinking in the case that the original dataset source may change (and the addresses inside of the dataset will change).

image
image752×326 25.6 KB

2

I prefer to use an expression so I can wrap it in a try and return a default value if needed, or a blank string

try({Path/To/DataSet/Tag}[0,'ColumnNameOrIndex'],'')

3

thanks