This is an old revision of the document!

Specific Examples

These queries show specific examples of some real-world possible queries.

Show All Valves

'Valve' TYPE ISTYPE

http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE

Get all Valves on Boiler #1

'Stove #1' ASSET 'Location' RELATIONSHIP 'down' RELATED 'Valve' TYPE ISTYPE

http://demo.optrix.com.au/s/bf/aql/show?query=%27Stove%20%231%27%20ASSET%20%27Location%27%20RELATIONSHIP%20%27down%27%20RELATED%20%27Valve%27%20TYPE%20ISTYPE

Get a list of all of the open analogue valves

'Valve' TYPE ISTYPE ('Position') PROPERTY POINTS '50' GREATER

http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE%20(%27Position%27)%20PROPERTY%20POINTS%20%2750%27%20GREATER

Get a list of all of the open on/off valves

'Valve' TYPE ISTYPE THAT ARE('Open')

http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE%20THAT%20ARE(%27Open%27)

Get the currently active stove

'Stove' TYPE ISTYPE THAT ARE('Active')

http://demo.optrix.com.au/s/bf/aql/show?query=%27Stove%27%20TYPE%20ISTYPE%20THAT%20ARE(%27Active%27)

Find out how many Staves are over 650 degrees

'Stave' TYPE ISTYPE 'Temperature - Stave' PROPERTY POINTS '650' GREATER COUNT

http://demo.optrix.com.au/s/bf/aql/show?query=%27Stave%27%20TYPE%20ISTYPE%20%27Temperature%20-%20Stave%27%20PROPERTY%20POINTS%20%27650%27%20GREATER%20COUNT

Find the hottest stave(s)

'Stave' TYPE ISTYPE 'Temperature - Stave' PROPERTY POINTS MAXIMUM

http://demo.optrix.com.au/s/bf/aql/show?query=%27Stave%27%20TYPE%20ISTYPE%20%27Temperature%20-%20Stave%27%20PROPERTY%20POINTS%20MAXIMUM

Get a heatmap of the stove temperatures over time

'TE101' ASSET 'Profile' RELATIONSHIP 'downi' RELATED 'Temperature - Stove' PROPERTY POINTS { “start”: “2020-01-01 00:00:00”, “end”: “2020-01-02 00:00:00” } GETHISTORY

http://demo.optrix.com.au/s/bf/aql/show?query=%27TE101%27%20ASSET%20%27Profile%27%20RELATIONSHIP%20%27downi%27%20RELATED%20%27Temperature%20-%20Stove%27%20PROPERTY%20POINTS%20%7B%20%22start%22:%20%222020-01-01%2000:00:00%22,%20%22end%22:%20%222020-01-02%2000:00:00%22%20%7D%20GETHISTORY

Get a heatmap of the stave temperatures horizontally and vertically

'TE501' ASSET 'Vertical Profile' RELATIONSHIP 'downi' RELATED [ 'Profile' RELATIONSHIP 'downi' RELATED ] EACH [ 'Temperature' PROPERTY POINTS ] FOR

http://demo.optrix.com.au/s/bf/aql/show?query=%27TE501%27%20ASSET%20%27Vertical%20Profile%27%20RELATIONSHIP%20%27downi%27%20RELATED%20[%20%27Profile%27%20RELATIONSHIP%20%27downi%27%20RELATED%20]%20EACH%20[%20%27Temperature%27%20PROPERTY%20POINTS%20]%20FOR