====Specific Examples====

These queries show //specific// examples of some real-world possible queries, based on our **Blast Furnace Demo** located at http://demo.optrix.com.au/s/bf
----
===Show All Valves===

**'Valve' [[fTYPE]] [[fISTYPE]]**


[[http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE|Run Live (JSON)]]

----
===Get all Valves on Stove #1===

**'Stove #1' [[fASSET]] 'Location' [[fRELATIONSHIP]] 'down' [[fRELATED]] 'Valve' [[fTYPE]] [[fISTYPE]]**

[[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|Run Live]]
----
===Show all of the properties on sensor TE101===

**'TE101' [[fASSET]] [[fALLPOINTS]]**

[[http://demo.optrix.com.au/s/bf/aql/show?query=%27TE101%27%20ASSET%20ALLPOINTS|Run Live]]
----
===Get a list of all of the open analogue valves===

**'Valve' [[fTYPE]] [[fISTYPE]] ('Position') [[fPROPERTY]] [[fPOINTS]] '50' [[fGREATER]]**

[[http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE%20%28%27Position%27%29%20PROPERTY%20POINTS%20%2750%27%20GREATER|Run Live]]

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

**'Valve' [[fTYPE]] [[fISTYPE]] [[mhasenumvalue|THAT ARE]]('Open')**

[[http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE%20THAT%20ARE%28%27Open%27%29|Run Live]]
----
===Get the currently active stove===

**'Stove' [[fTYPE]] [[fISTYPE]] [[mhasenumvalue|THAT ARE]]('Active')**

[[http://demo.optrix.com.au/s/bf/aql/show?query=%27Stove%27%20TYPE%20ISTYPE%20THAT%20ARE%28%27Active%27%29|Run Live]]

----
===Find out how many Staves are over 650 degrees===

**'Stave' [[fTYPE]] [[fISTYPE]] 'Temperature - Stave' [[fPROPERTY]] [[fPOINTS]] '650' [[fGREATER]] [[fCOUNT]]**

[[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|Run Live]]

----
===Find the hottest stave(s)===

**'Stave' [[fTYPE]] [[fISTYPE]] 'Temperature - Stave' [[fPROPERTY]] [[fPOINTS]] [[fMAXIMUM]]**

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

----
===Get a heatmap of the stove temperatures over time===

**'TE101' [[fASSET]] 'Profile' [[fRELATIONSHIP]] 'downi' [[fRELATED]] 'Temperature - Stove' [[fPROPERTY]] [[fPOINTS]] { "start": "2020-01-01 00:00:00", "end": "2020-01-02 00:00:00" } [[fGETHISTORY]]**

[[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|Run Live]]

----
===Get a heatmap of the stave temperatures horizontally and vertically===

**'TE501' [[fASSET]] 'Vertical Profile' [[fRELATIONSHIP]] 'downi' [[fRELATED]] [ 'Profile' [[fRELATIONSHIP]] 'downi' [[fRELATED]] ] [[fEACH]] [ 'Temperature' [[fPROPERTY]] [[fPOINTS]] ] [[fFOR]]**

[[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|Run Live]]