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

Get a list of all of the open analogue valves

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

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

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

Get the currently active stove

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

Find out how many Staves are over 1000 degrees

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

Find the hottest stave(s)

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

Get a heatmap of the stove temperatures over time

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

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