AQL Reference - Alphabetical

A

AMacro for ASSET (macro)
ALLPOINTSGet all points for a given asset
ALLPROPSGet all properties available on a given asset
AIPOINTSGet a list of contextual points around an asset
ANDCombines two time lists, returning only common times
APPENDCombines two lists, one after the other
ASSETSearch for an asset by name or ID
AVERAGEReturns the average value in a point list

C

CONCATAdds two items to form a text string
COUNTGets the number of items in a list or map
CONTAINSReturns '1' if a list contains an item, otherwise 0

D

DUPDuplicate the top item on the stack
DVALUESGet the points for an asset and property, searching down-stream

E

EACHRun a function for each item in a list
EATRemove the item from the top of the stack
ENUMVALUESGets possible values of discrete properties
ENUMFILTERGets all property/value combinations for an enum text value
EQUALFilter for only items equal to a value

F

FORRun a function on every item in the stack

G

GETGet a value from memory
GETHISTORYGets historical values from a list of points
GETTABLEGets the contents of a table
GREATERFilter for only items greater than a value

H

HAVERAGECalculate the average of the history for a point list]]
HMAXIMUM
HMINIMUMCalculate the minimum of the history for a point list]]

I

IFRun a function if a condition is met
IGNOREAlias for the EAT function
INDEXGet a specific item from a list or map
INSIDEAll items located inside an asset
ISTYPEReturns a list of assets that have a type

L

LAGOffset the date of a GETHISTORY request
LESSFilter for only items less than a value

M

MAXIMUMReturns the maximum value in a point list
MAPFILTERFilter a Map
MAPSETSet or add items in a map
MEDIAGets media from a list of assets
MEDIANReturns the average value in a point list
MINIMUMReturns the minimum value in a point list

N

NAMEAssign a name to the item on the stack

O

ORCombines two time lists to include either time
OUTSIDEAll items located inside an asset

P

PMacro for PROPERTY (macro)
PROPERTYSearch for a Property by name or ID
PUTSet a value in memory and leave on the stack

R

RMacro for RELATIONSHIP (macro)
RANGECreates a sequence of numbers between two points
RELSGet all relationships for an asset
RELATEDGet a list of related assets
RELATIONSHIPTranslate a name to a relationship
REMOVERemove an asset or property from a list
ROOTGet the root asset of a hierarchy

S

SETSet a value in memory
SELECTASSETSSelects assets with a Selector expression
SELECTPOINTSSelects points with a Selector expression
SMOOTHSmooths historical samples
SOURCEDFROMGets a list of points that are read from this Data Source
SUBTYPESGets a list of sub-types of a given type
SWAPSwap the order of the stack

T

TORATEConvert a total/counter value to a rate
TOTALCalculate a total value based on a rate
TYPEGets a type by name
THAT AREGet value based on enum (macro)

U

UNLAGAdjust the timestamps in a point list
UVALUESGet the points for an asset and property, searching up-stream

W

WHENReturns a list of times from history where a condition is true

V

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

Z

ZIPCombines two lists by alternating items between each of them