OR
Parameters
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”