====AQL Reference - Alphabetical====

===A===
|[[mA|A]]|Macro for [[fASSET|ASSET]] //(macro)//|
|[[fALLPOINTS]]|Get all points for a given asset|
|[[fALLPROPS]]|Get all properties available on a given asset|
|[[fAIPOINTS]]|Get a list of contextual points around an asset|
|[[fAND]]|Combines two time lists, returning only common times|
|[[fAPPEND]]|Combines two lists, one after the other|
|[[fASSET|ASSET]]|Search for an asset by name or ID|
|[[fAVG]]|Returns the average value in a point list|

===C===
|[[fCONCAT]]|Adds two items to form a text string|
|[[fCOUNT]]|Gets the number of items in a list or map|
|[[fCONTAINS]]|Returns '1' if a list contains an item, otherwise 0|

===D===
|[[fDROP]]|Drops (remove) results from the query|
|[[fDUP]]|Duplicate the top item on the stack|
|[[fDVALUE]]|Get the [[point list|points]] for an asset and property, searching down-stream|


===E===
|[[fEACH]]|Run a function for each item in a list|
|[[fEAT]]|Remove the item from the top of the stack|
|[[fENUMVALUES]]|Gets possible values of discrete properties|
|[[fENUMFILTER]]|Gets all property/value combinations for an enum text value|
|[[fEQUAL]]|Filter for only items equal to a value|

===F===
|[[fFOR]]|Run a function on every item in the stack|

===G===
|[[fGET]]|Get a value from memory|
|[[fGETHISTORY]]|Gets historical values from a list of points|
|[[fGETTABLE]]|Gets the contents of a table|
|[[fGREATER]]|Filter for only items greater than a value|

===H===
|[[fHAVERAGE]]|Calculate the average of the history for a point list]]|
|[[fHMAXIMUM]]|Calculate the maximum of the history for a point list]]
|[[fHMINIMUM]]|Calculate the minimum of the history for a point list]]|
|
===I===
|[[fIF]]|Run a function if a condition is met|
|[[mIGNORE]]|Alias for the [[fEAT]] function|
|[[fINDEX]]|Get a specific item from a list or map|
|[[mINSIDE]]|All items located inside an asset|
|[[fISTYPE]]|Returns a list of assets that have a type|

===L===
|[[fLAG]]|Offset the date of a [[fGETHISTORY]] request|
|[[fLESS]]|Filter for only items less than a value|

===M===
|[[fMAXIMUM]]|Returns the maximum value in a point list|
|[[fMAPFILTER]]|Filter a Map|
|[[fMAPSET]]|Set or add items in a map|
|[[fMEDIA]]|Gets media from a list of assets|
|[[fMEDIAN]]|Returns the average value in a point list|
|[[fMINIMUM]]|Returns the minimum value in a point list|

===N===
|[[fNAME]]|Assign a name to the item on the stack|

===O===
|[[fOR]]|Combines two time lists to include either time|
|[[fOFTYPE]]|Gets all assets of a type|
|[[mOUTSIDE]]|All items located inside an asset|

===P===
|[[mP|P]]|Macro for [[fPROPERTY|PROPERTY]] //(macro)//|
|[[fPROPERTY|PROPERTY]]|Search for a Property by name or ID|
|[[fPUT]]|Set a value in memory and leave on the stack|

===R===
|[[mR|R]]|Macro for [[fRELATIONSHIP|RELATIONSHIP]] //(macro)//|
|[[fRANGE]]|Creates a sequence of numbers between two points|
|[[fRELS]]|Get all relationships for an asset|
|[[fRELATED]]|Get a list of related assets|
|[[fRELATIONSHIP]]|Translate a name to a relationship|
|[[fREMOVE]]|Remove an asset or property from a list|
|[[fROOT]]|Get the root asset of a hierarchy|

===S===
|[[fSET]]|Set a value in memory|
|[[fSELECTASSETS]]|Selects assets with a [[selectors:start|Selector]] expression|
|[[fSELECTPOINTS]]|Selects points with a [[selectors:start|Selector]] expression|
|[[fSMOOTH]]|Smooths historical samples|
|[[fSOURCEDFROM]]|Gets a list of points that are read from this Data Source|
|[[fSUBTYPES]]|Gets a list of sub-types of a given type|
|[[fSWAP]]|Swap the order of the stack|

===T===
|[[fTORATE]]|Convert a total/counter value to a rate|
|[[fTOTAL]]|Calculate a total value based on a rate|
|[[fTYPE]]|Gets a type by name|
|[[mHASENUMVALUE]]|Get value based on enum //(macro)//|

===U===
|[[fUNLAG]]|Adjust the timestamps in a [[point list|point list]]|
|[[fUVALUE]]|Get the [[point list|points]] for an asset and property, searching up-stream|

===W===
|[[fWHEN]]|Returns a list of times from history where a condition is true|

===V===
|[[mVALUES|VALUES]]|Get the [[point list|points]] for a given asset and property //(macro)//|

===Z===
|[[fZIP|ZIP]]|Combines two lists by alternating items between each of them|