AQL Reference - Alphabetical [Optrix Documentation]

Trace: • Macros • AQL Reference - Alphabetical

AQL Reference - Alphabetical

A

A	Macro for ASSET (macro)
ALLPOINTS	Get all points for a given asset
ALLPROPS	Get all properties available on a given asset
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

C

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
mCONNECTIONS	Get all directly connected assets (macro)

D

DUP	Duplicate the top item on the stack

E

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

G

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

I

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
ISTYPE	Returns a list of assets that have a type

L

LESS	Filter for only items less than a value

M

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

N

NAME	Assign a name to the item on the stack

P

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

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
SUBTYPES	Get the root asset of a hierarchy

S

SET	Set a value in memory
SUBTYPES	Gets a list of sub-types of a given type
SWAP	Swap the order of the stack

T

TYPE	Gets a type by name
THAT ARE	Get value based on enum (macro)

V

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

Z

ZIP	Combines two lists by alternating items between each of them