Returns a list with all annotations stored on the variables informed in the @node parameter.

Syntax

SELECT * FROM EpmQueryAnnotationsFunction(<[float]@timeZoneOffset>,
  <[datetime]@startTime>, <[datetime]@endTime>, <[string]@node>)

Parameters

•<[float]@timeZoneOffset>: Timezone to consider. Possible values range from -12 to 14

•<[datetime]@startTime>: Initial date of the period to retrieve. This must be a String in the format yyyy-MM-dd HH:mm:ss

•<[datetime]@endTime>: Final date of the period to retrieve. This must be a String in the format yyyy-MM-dd HH:mm:ss

•<[string]@node>: Variable or variables to retrieve. Users must inform a full name or names between single quotes and separated by commas

Result Fields

•Name: Name of a variable or variables retrieved

•Timestamp: Timestamp of annotations found

•Message: Message of the annotations

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

Example

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

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

EpmQueryAnnotationsFunction function