Returns data from a query containing the configuration of pens, types of aggregation, and period of the Data Server informed in the @datasetName parameter.

Syntax

SELECT Name, Timestamp, Quality, <type_function>(Value)
  FROM EpmQueryDataset(<[string]@datasetName>)

Parameters

•<type_function>: Conversion function to define a data type for the resulting values on the Value column. Possible values are described on topic EpmReadPropertyFunction

•<[string]@datasetName>: Full name of a Dataset Server to search for, which must be between single quotes

Result Fields

•Name: Name of a variable or variables retrieved

•Timestamp: Timestamp of data retrieved

•Quality: Quality of data retrieved

•Value: Value of data retrieved

Example

To return a table based on the settings of the ODBC_Dataset Dataset, use the next statement. The type of the RandomTags_Random1 pen is Raw and the type of the RandomTags_Random10 is Interpolative with an interval of 30 seconds.

SELECT Name, Timestamp, Quality, doubleval(value) FROM EpmQueryDataset('ODBC_Dataset')

EpmQueryDataset function

Chart with the EpmQueryDataset function