Initial values and use of >= - j5 - 28.0 - Help - Hexagon PPM

j5 Wonderware Historian Datasource Connector Help

Language
English (United States)
Product
j5
Search by Category
Help
j5 Version
2019

Querying the start time in exclusive form with the > operator indicates that a value should not be returned for the query start time if one does not exist. Querying the start time in inclusive form with the >= operator indicates that an initial value should be returned.

For example, the following exclusive query statement does not return an initial value for 2009-01-01 02:00:00:

DateTime > '2009-01-01 02:00:00'

However, the following inclusive query statement does return an initial value for 2009-01-01 02:00:00:

DateTime >= '2009-01-01 02:00:00'

No special final value is returned.