Get Query

This layer loads table from an AQL query.

Parameters

NameDefaultMeaning
queryAn AQL query
pointsA list of ARDI point selectors
samples1000The number of samples in the query

Note

This layer may cause the query to split if you have more than one timeframe or table column.

Description

This function loads a table of information from an AQL query or a set of ARDI points.

Using Points

Points are in the standard ARDI selector format, such as asset name.property name.

Using AQL Query

If the query doesn't include the GETHISTORY function, it will be automatically added with a time range matching the start and end time of the current frame.

Example

{
   "type": "get_aql",
   "points": ["Machine.Speed"]
   "samples": 200
}

The layer above will read approx. 200 samples of machine speed data into a table.

{
   "type": "get_aql",
   "query": "'Machine' ASSET 'Speed' PROPERTY VALUES",
   "samples": 200
}

Just like the above example, but this time using an AQL-style query.

{
   "type": "get_aql",
   "query": "'Machine' ASSET AIPOINTS",
   "samples": 200
}

This function gets all of the related points about the asset called “Machine”.