Returns a list of all annotations recorded in the variables informed in the @node parameter.

Syntax

SELECT * FROM EpmQueryAnnotationsFunction(@timeZoneOffset, @startTime, @endTime, @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

•@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 queried

•Timestamp: Timestamp of the annotations found

•Message: Message contained in the annotations

•UserName: Name of the EPM user who added the annotations

Usage Example

To return all annotations recorded for the variable test_variable in the period between 21:37 and 21:47 on 12/17/2020, with a timezone of -3 (minus three) hours, use the next declaration.

SELECT * FROM EpmQueryAnnotationsFunction(-3, '2020-12-17 21:37:00', '2020-12-17 21:47:00', 'test_variable')