Queries example

Within QueryString, you can use the placeholder values listed below to streamline query configuration. Delimit the placeholders with question marks. Placeholders include:

• ?LST? : Last Scan Time. This is a timestamp representing the time the agent ran the last scan.

• ?ET? : End Time. If the agent is in a history recovery mode, this will be the ?ST? value plus the RequestInterval specified in the data source configuration. For example, if RequestInterval is set to 1 hour, there will be an hour difference between ?ST? and ?ET?. If the agent is not in history recovery mode, this will be replaced with the current time.

• ?ST? : Start Time. If the agent is in history recovery mode, this placeholder will be replaced by the StartTime specified in the history recovery configuration on the first scan. After the first scan during history recovery, this placeholder will be replaced by the timestamp of the last event collected. If the agent is not in history recovery mode, this will be replaced with last scan time, i.e. the timestamp representing the time agent ran the last scan.

The following is an example of a valid AVEVA Events to CONNECT Queries configuration:

[

{

"queryId": "1",

"queryString": "/"

},

{

"queryId": "ReferenceDataTypeIdQuery1",

"queryString": "?typeId=SampleReferenceDataType1535126"

},

{

"queryId": "EventsTypeIdQuery1",

"queryString": "?typeId=SampleEventType1304944&eventStartTimeFilter=?ST?&eventEndTimeFilter=?ET?"

}

]