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:03] optrix |
aql:specific_examples [2020/01/21 04:09] (current) optrix |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| 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 | 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=== | ||
| Line 10: | Line 10: | ||
| Example: http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE | Example: http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE | ||
| - | + | ---- | |
| - | ===Get all Valves on Boiler #1=== | + | ===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]]** | ||
| - | Example: 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')** | ||
| - | Example: 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=== | ||
| Line 43: | Line 49: | ||
| 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 | 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)=== | ||
| Line 50: | Line 56: | ||
| Example: 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=== | ||
| Line 57: | Line 63: | ||
| 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 | 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=== | ||