|
<< Click to Display Table of Contents >>
EpmRecordedValueFunction |
Returns data from one or more variables effectively stored, as informed in the @retrievalMode parameter.
SELECT Name, Timestamp, Quality, Value FROM EpmRecordedValueFunction(@timeZoneOffset, @timestamp, @retrievalMode, @node)
•@timeZoneOffset: Timezone to consider. Possible values range between -12 and 14
•@timestamp: Time to consider for retrieving data. Users must use a String in the format yyyy-MM-dd HH:mm:ss
•@retrievalMode: Way to retrieve data. Possible values for this parameter must be informed between single quotes and they are defined on the next table
•@node: Variable or variables to query
Possible values for the @retrievalMode parameter
Value |
Description |
|---|---|
Previous |
Defines a search for the first data before the time informed in the @timestamp parameter |
Exact |
Defines a search for the current data at the exact moment informed in the @timestamp parameter |
Next |
Defines a search for the first data after the time informed in the @timestamp parameter |
•Name: Name of the variable or variables to query
•Timestamp: Timestamp of data found
•Quality: Quality of data found
•Value: Value of data found
To return a table with values found before the moment this query is executed for variables RandomTags_Random1 and RandomTags_Random10 at 10:23 on 12/07/2020, with a timezone of -3 (minus three) hours, use the next declaration.
SELECT Name, Timestamp, Quality, Value FROM EpmRecordedValueFunction(-3, '2020-12-07 10:23:00', 'Previous', 'RandomTags_Random1,Random_Tags_Random10')