AQL Reference

This is an old revision of the document!

A	Macro for ASSET (macro)
ALLPOINTS	Get all points for a given asset
ALLPROPS	Get all properties available on a given asset
AIPOINTS	Get a list of contextual points around an asset
AND	Combines two time lists, returning only common times
APPEND	Combines two lists, one after the other
ASSET	Search for an asset by name or ID
AVERAGE	Returns the average value in a point list

CONCAT	Adds two items to form a text string
COUNT	Gets the number of items in a list or map
CONTAINS	Returns '1' if a list contains an item, otherwise 0

DUP	Duplicate the top item on the stack
DVALUES	Get the points for an asset and property, searching down-stream

EACH	Run a function for each item in a list
EAT	Remove the item from the top of the stack
ENUMVALUES	Gets possible values of discrete properties
ENUMFILTER	Gets all property/value combinations for an enum text value
EQUAL	Filter for only items equal to a value

FOR	Run a function on every item in the stack

GET	Get a value from memory
GETHISTORY	Gets historical values from a list of points
GETTABLE	Gets the contents of a table
GREATER	Filter for only items greater than a value

HAVERAGE	Calculate the average of the history for a point list]]
HMAXIMUM
HMINIMUM	Calculate the minimum of the history for a point list]]

IF	Run a function if a condition is met
IGNORE	Alias for the EAT function
INDEX	Get a specific item from a list or map
INSIDE	All items located inside an asset
ISTYPE	Returns a list of assets that have a type

LAG	Offset the date of a GETHISTORY request
LESS	Filter for only items less than a value

MAXIMUM	Returns the maximum value in a point list
MAPFILTER	Filter a Map
MAPSET	Set or add items in a map
MEDIA	Gets media from a list of assets
MEDIAN	Returns the average value in a point list
MINIMUM	Returns the minimum value in a point list

NAME	Assign a name to the item on the stack

OR	Combines two time lists to include either time
OUTSIDE	All items located inside an asset

P	Macro for PROPERTY (macro)
PROPERTY	Search for a Property by name or ID
PUT	Set a value in memory and leave on the stack

R	Macro for RELATIONSHIP (macro)
RANGE	Creates a sequence of numbers between two points
RELS	Get all relationships for an asset
RELATED	Get a list of related assets
RELATIONSHIP	Translate a name to a relationship
REMOVE	Remove an asset or property from a list
ROOT	Get the root asset of a hierarchy

SET	Set a value in memory
SELECTASSETS	Selects assets with a Selector expression
SELECTPOINTS	Selects points with a Selector expression
SMOOTH	Smooths historical samples
SOURCEDFROM	Gets a list of points that are read from this Data Source
SUBTYPES	Gets a list of sub-types of a given type
SWAP	Swap the order of the stack

TORATE	Convert a total/counter value to a rate
TOTAL	Calculate a total value based on a rate
TYPE	Gets a type by name
THAT ARE	Get value based on enum (macro)

UNLAG	Adjust the timestamps in a point list
UVALUES	Get the points for an asset and property, searching up-stream

WHEN	Returns a list of times from history where a condition is true

Get the points for a given asset and property (macro)

ZIP	Combines two lists by alternating items between each of them