Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
aql:specific_examples [2020/01/21 04:08] 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 Stove #1=== | ===Get all Valves on Stove #1=== | ||
| Line 16: | Line 16: | ||
| 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=== | ===Show all of the properties on sensor TE101=== | ||
| Line 22: | Line 22: | ||
| Example: http://demo.optrix.com.au/s/bf/aql/show?query=%27TE101%27%20ASSET%20ALLPOINTS | 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=== | ||
| Line 29: | Line 29: | ||
| 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 | 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=== | ||
| Line 35: | Line 35: | ||
| http://demo.optrix.com.au/s/bf/aql/show?query=%27Valve%27%20TYPE%20ISTYPE%20THAT%20ARE%28%27Open%27%29 | 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=== | ||
| Line 42: | Line 42: | ||
| Example: http://demo.optrix.com.au/s/bf/aql/show?query=%27Stove%27%20TYPE%20ISTYPE%20THAT%20ARE%28%27Active%27%29 | 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 49: | 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 56: | 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 63: | 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=== | ||