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 03:30] 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]]** | ||
| - | ===Get all Valves on Boiler #1=== | ||
| - | **'Boiler #1' [[fASSET]] 'Location' [[fRELATIONSHIP]] 'down' [[fRELATED]] 'Valve' [[fTYPE]] [[fISTYPE]]** | + | 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]]** | ||
| + | |||
| + | 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 - Valve') [[fPROPERTY]] [[fPOINTS]] '50' [[fGREATER]]** | + | **'Valve' [[fTYPE]] [[fISTYPE]] ('Position') [[fPROPERTY]] [[fPOINTS]] '50' [[fGREATER]]** |
| + | 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%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')** | ||
| - | ===Find out how many Staves are over 1000 degrees=== | + | Example: http://demo.optrix.com.au/s/bf/aql/show?query=%27Stove%27%20TYPE%20ISTYPE%20THAT%20ARE%28%27Active%27%29 |
| - | **'Stave' [[fTYPE]] [[fISTYPE]] 'Temperature - Stave' [[fPROPERTY]] [[fPOINTS]] '1000' [[fGREATER]] [[fCOUNT]]** | + | ---- |
| + | ===Find out how many Staves are over 650 degrees=== | ||
| + | **'Stave' [[fTYPE]] [[fISTYPE]] 'Temperature - Stave' [[fPROPERTY]] [[fPOINTS]] '650' [[fGREATER]] [[fCOUNT]]** | ||
| + | |||
| + | 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]] '1000' [[fGREATER]] [[fMAXIMUM]]** | + | **'Stave' [[fTYPE]] [[fISTYPE]] 'Temperature - Stave' [[fPROPERTY]] [[fPOINTS]] [[fMAXIMUM]]** |
| + | 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=== | ||
| - | **'Stove #1' [[fASSET]] 'Profile' [[fRELATIONSHIP]] 'downi' [[fREALATED]] 'Temperature' [[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]]** |
| + | |||
| + | 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=== | ||
| + | |||
| + | **'TE501' [[fASSET]] 'Vertical Profile' [[fRELATIONSHIP]] 'downi' [[fRELATED]] [ 'Profile' [[fRELATIONSHIP]] 'downi' [[fRELATED]] ] [[fEACH]] [ 'Temperature' [[fPROPERTY]] [[fPOINTS]] ] [[fFOR]]** | ||
| + | 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 | ||