Tag historian query and sub query

[marco_alvarez]

Hi, Im using a Tag historian query to bring a bunch of tags, then I want to use a sub query(child) to separate all the tag in different categories, but I dont know how to reference the tags Im bringing from the tag historian query. Something like select * from historialDataSource where name = machine1. Which is the right syntax for this.

[pturmel]

So, your getting a dataset from a historian query or query binding, and you want to SELECT within that dataset? If so, you are in luck:

Automation Professionals' Integration Toolkit Module

Automation Professionals is pleased to announce the immediately availability of a major upgrade to its free Simulation Aids Integration Toolkit module. The new feature justifying the "major upgrade" language is the implementation of eleven thirty-one new expression functions which use iteration to accomplish complex transforms of datasets and lists, to or from other datasets and lists, applying filtering, ordering, and computed new columns along the way. While there are certain operations that…

Specifically, the view() expression function and its ability to use "Pseudo-SQL" for your task.

[marco_alvarez]

I end up using just historian data source

with a {device_number} parameter to select between different devices