Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
aql:specific_examples [2020/01/21 04:00] optrix |
aql:specific_examples [2020/01/21 04:09] (current) optrix |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====Specific Examples==== | ====Specific Examples==== | ||
| - | These queries show //specific// examples of some real-world possible queries. | + | 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=== | ===Show All Valves=== | ||
| **'Valve' [[fTYPE]] [[fISTYPE]]** | **'Valve' [[fTYPE]] [[fISTYPE]]** | ||
| - | http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE | ||
| - | ===Get all Valves on Boiler #1=== | + | Example: http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE |
| + | |||
| + | ---- | ||
| + | ===Get all Valves on Stove #1=== | ||
| **'Stove #1' [[fASSET]] 'Location' [[fRELATIONSHIP]] 'down' [[fRELATED]] 'Valve' [[fTYPE]] [[fISTYPE]]** | **'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 | 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 | ||
| + | ---- | ||
| + | ===Show all of the properties on sensor TE101=== | ||
| + | **'TE101' [[fASSET]] [[fALLPOINTS]]** | ||
| + | |||
| + | Example: http://demo.optrix.com.au/s/bf/aql/show?query=%27TE101%27%20ASSET%20ALLPOINTS | ||
| + | ---- | ||
| ===Get a list of all of the open analogue valves=== | ===Get a list of all of the open analogue valves=== | ||
| **'Valve' [[fTYPE]] [[fISTYPE]] ('Position') [[fPROPERTY]] [[fPOINTS]] '50' [[fGREATER]]** | **'Valve' [[fTYPE]] [[fISTYPE]] ('Position') [[fPROPERTY]] [[fPOINTS]] '50' [[fGREATER]]** | ||
| - | http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE%20(%27Position%27)%20PROPERTY%20POINTS%20%2750%27%20GREATER | + | Example: 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 |
| + | ---- | ||
| ===Get a list of all of the open on/off valves=== | ===Get a list of all of the open on/off valves=== | ||
| **'Valve' [[fTYPE]] [[fISTYPE]] [[mhasenumvalue|THAT ARE]]('Open')** | **'Valve' [[fTYPE]] [[fISTYPE]] [[mhasenumvalue|THAT ARE]]('Open')** | ||
| - | http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE%20THAT%20ARE(%27Open%27) | + | http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE%20THAT%20ARE%28%27Open%27%29 |
| + | ---- | ||
| ===Get the currently active stove=== | ===Get the currently active stove=== | ||
| **'Stove' [[fTYPE]] [[fISTYPE]] [[mhasenumvalue|THAT ARE]]('Active')** | **'Stove' [[fTYPE]] [[fISTYPE]] [[mhasenumvalue|THAT ARE]]('Active')** | ||
| - | http://demo.optrix.com.au/s/bf/aql/show?query=%27Stove%27%20TYPE%20ISTYPE%20THAT%20ARE(%27Active%27) | + | Example: http://demo.optrix.com.au/s/bf/aql/show?query=%27Stove%27%20TYPE%20ISTYPE%20THAT%20ARE%28%27Active%27%29 |
| + | ---- | ||
| ===Find out how many Staves are over 650 degrees=== | ===Find out how many Staves are over 650 degrees=== | ||
| **'Stave' [[fTYPE]] [[fISTYPE]] 'Temperature - Stave' [[fPROPERTY]] [[fPOINTS]] '650' [[fGREATER]] [[fCOUNT]]** | **'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 | + | Example: 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)=== | ===Find the hottest stave(s)=== | ||
| **'Stave' [[fTYPE]] [[fISTYPE]] 'Temperature - Stave' [[fPROPERTY]] [[fPOINTS]] [[fMAXIMUM]]** | **'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 | + | Example: 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=== | ===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]]** | **'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%7C%20GETHISTORY | + | Example: 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=== | ===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]]** | **'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 | + | Example: 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 |