EpmQueryRawFunction

<< Click to Display Table of Contents >>

 

EpmQueryRawFunction

Returns all data from one or more variables informed in the @node parameter, recorded in the queried period.

 

Syntax

SELECT Name, Timestamp, Quality, Value FROM EpmQueryRawFunction(@timeZoneOffset, @startTime, @endTime, @valuesPerNode, @returnBounds, @node)

 

Parameters

@timeZoneOffset: Timezone to consider. Possible values range between -12 and 14

@startTime: Initial date of the period to query. Users must use a String in the format yyyy-MM-dd HH:mm:ss

@endTime: Final date of the period to query. Users must use a String in the format yyyy-MM-dd HH:mm:ss

@valuesPerNode: Informs the maximum number of values to return for each queried variable. A value of 0 (zero) indicates that there is no limit

@returnBounds: Defines whether the value previous to the first value found in the queried period and the value after the last value queried must be returned. Possible values are 1 (one, True) or 0 (zero, False)

@node: Variable or variables to query. Users must inform the full name or names between single quotes and comma-separated

 

Resulting Fields

Name: Name of the variable or variables to query

Timestamp: Timestamp of data found

Quality: Quality of data found

Value: Value of data found

 

Usage Example

To return raw data, that is, all data effectively stored in the RandomTags_Random1 variable in the period between 10:23 and 11:23 on 12/07/2020, with a timezone of -3 (minus three) hours, also returning the value immediately before the beginning of the queried period, use the next declaration.

SELECT Name, Timestamp, Quality, Value FROM EpmQueryRawFunction(-3, '2020-12-07 10:23:00', '2020-12-07 11:23:00', 0, 1, 'RandomTags_Random1')

Was this page useful?