OR

Parameters

OrderNameTypeDesc
1frame_aTime ListThe first set of times
1frame_bTime ListThe second set of times

Returns

Places a time list on the stack.

Description

This function calculates the time frames where either frame_a and frame_b where active.

Example

In this example, we have a primary and a spare pump delivering water to our facility.

We would like to see how much time either (or both) of the pumps were running.

First, we make a query to get times from Pump A…

'Pump A' ASSET 'Running' PROPERTY VALUES { “range”: “24 hours”, “method”: “raw” } GETHISTORY [ 1 EQUAL ] WHEN

And a very similar query for Pump B…

'Pump B' ASSET 'Running' PROPERTY VALUES { “range”: “24 hours”, “method”: “raw” } GETHISTORY [ 1 EQUAL ] WHEN

Our final query can and these two together…

'Pump A' ASSET 'Running' PROPERTY VALUES { “range”: “24 hours”, “method”: “raw” } GETHISTORY [ 1 EQUAL ] WHERE 'Pump B' ASSET 'Running' PROPERTY VALUES { “range”: “24 hours”, “method”: “raw” } GETHISTORY [ 1 EQUAL ] WHEN AND HOURS

This translates to “Show me the total number of hours where either or both of the pumps were running over the last 24 hours”

See Also