TimeGE

Find the total time, within a range, when an attribute value is greater than or equal to a specified value. Time returned is in seconds.

Syntax

TimeGE(attname, starttime, endtime, x)

Arguments

• attname

  The name of an attribute with a PI point data reference, enclosed in single quotation marks

• starttime

  time expression representing the beginning of a time range enclosed in single quotes; can be a relative time (such as '-3h') in reference to an absolute endtime

• endtime

  time expression representing the end of a time range enclosed in single quotes; can be a relative time (such as '+1h') in reference to an absolute starttime

• x

  The reference value of the search; must be an enumeration set (string), integer or real number

Returns

The total time (in seconds), within a range, when an attribute value is greater than or equal to a given value

Exceptions

None

Notes

TimeGE interpolates between events, if necessary, to find the times when the attribute value crossed the given value

Bad values are excluded from TimeGE calculation

Example

• TimeGE('att1', 't', '+1h', 80)

  [Find the total time between 12:00 and 1:00am today when 'att1' was greater than or equal to 80]

• TimeGE('att1', '-1h', '*', TagVal('att1', 't+8h'))

  [Find the total time in the past hour when the value of 'att1' was greater than or equal to the value at 8am today. Result is in seconds]

• TimeGE('enum_att1', '*-1d', '*', DigState("Normal", 'enum_att1'))