Functions list
The following table lists all available XQL functions:
Calculate the inverse cosine (arccosine) of a numerical expression
Calculate the inverse hyperbolic cosine of a numeric value
Calculate the sum of two numbers
Return an approximate count of distinct values
Return approximate quantile boundaries
Return the approximate top values
Calculate the inverse sine (arcsine) of a numerical expression
Calculate the inverse hyperbolic sine of a numeric value
Calculate the inverse tangent of a numeric value
Calculate the angle from two numeric coordinates
Calculate the inverse hyperbolic tangent of a numeric value
Check if all elements in an array match a condition
Check if any element in an array matches a condition
Return the number of elements in an array
Concatenate two arrays
Create an array from a list of values
Return an array with duplicate values removed
Filter elements of an array based on a condition
Return the element at a specified index in an array
Return the index of a value in an array
Apply a function to each element of an array
Merge multiple arrays into one
Create an array of sequential integers
Convert an array to a string
Calculate the average value using the comp stage
Calculate the average value using the windowcomp stage
Perform a bitwise AND operation between two integer values
Perform a bitwise OR operation between two integer values
Perform a bitwise left shift operation on an integer value
Perform a bitwise right shift operation on an integer value
Perform a bitwise exclusive OR (XOR) operation between two integer values
Calculate the cube root of a numeric value
Round a number up to the nearest integer
Return the first non-null value from a list
Concatenate two or more strings
Decode a Base64-encoded string
Encode a string to Base64
Calculate the cosine of a numeric value specified in radians
Calculate the hyperbolic cosine of a numeric value
Calculate the cosine distance between two numeric vectors
Calculate the cotangent of a numeric value specified in radians
Calculate the hyperbolic cotangent of a numeric value
Count values using the comp stage
Count values using the windowcomp stage
Count distinct values
Calculate the cosecant of a numeric value specified in radians
Calculate the hyperbolic cosecant of a numeric value
Return the current timestamp
Round a timestamp down to a specified time unit
Divide one number by another
Return the earliest timestamp value
Calculate the Euclidean distance between two numeric vectors
Calculate the value of e raised to the power of a numeric value
Extract a time component from a timestamp
Extract the host from a URL
Extract the public suffix from a URL
Extract the registered domain from a URL
Return the first value in a group
Return the first value in a window
Round a number down to the nearest integer
Format a string using a template
Format a timestamp as a string
Return the largest value from a list of expressions
Check whether an asset belongs to an organizational hierarchy node
Return one of two values based on a condition
Check if an IPv4 address is within a CIDR range
Check if an IPv6 address is within a CIDR range
Check if an IP address is within a list of CIDR ranges
Convert an integer to an IP address string
Convert an IP address string to an integer
Check if a value is a valid IPv4 address
Check if a value is a valid IPv6 address
Check if an IPv4 address is a known private address
Check if an IPv6 address is a known private address
Return whether an SLA has breached its goal
Extract a value from a JSON string
Extract an array from a JSON string
Extract a scalar value from a JSON string
Extract a scalar array from a JSON string
Extract a value from a JSON string using a JSONPath expression
json_functions_reference
Decide which JSON functions to use
Return the value of a field from a previous row in a window
Return the last value in a group
Return the last value in a window
Return the latest timestamp value
Return the smallest value from a list of expressions
Return the length of a string or array
Collect all values of a field and return them as an array within the comp stage
Calculate the natural logarithm (base e) of a numeric value
Calculate the logarithm of a numeric value with a specified base
Calculate the base-10 logarithm of a numeric value
Convert a string to lowercase
Remove leading whitespace from a string
Return the maximum value of a field within the comp stage
Compute the maximum value of a field over a window of rows within the windowcomp stage
Return the value associated with the maximum value in a group
Calculate the MD5 hash of a string
Return the median value of a numeric field within the comp stage
Compute the median value of a numeric field over a window of rows within the windowcomp stage
Return the minimum value of a field within the comp stage
Compute the minimum value of a field over a window of rows within the windowcomp stage
Return the value associated with the minimum value in a group
Calculate the remainder (modulus) of the division of two numeric values
Multiply two numbers
Create a JSON object from key-value pairs
Merge two JSON objects
Parse an epoch timestamp
Parse a timestamp string
Raise a number to a power
Raise a number to the power of another number (alias for pow)
Generate a pseudo-random floating-point number between 0 and 1
Determine which bucket a numeric value falls into given an array of boundaries
Assign a rank to each row within a partition in the windowcomp stage
Extract substrings using a regular expression
Extract a substring from a field value using a regular expression pattern
Replace occurrences of a substring
Replace substrings using a regular expression
Round a number to a specified number of decimal places
Assign a unique sequential integer to each row within a partition in the windowcomp stage
Remove trailing whitespace from a string
Perform addition with overflow protection, returning null on overflow
Perform division with error protection, returning null on division by zero
Perform multiplication with overflow protection, returning null on overflow
Negate a numeric value with overflow protection, returning null on overflow
Perform subtraction with overflow protection, returning null on overflow
Calculate the secant of a numeric value specified in radians
Calculate the hyperbolic secant of a numeric value
Calculate the SHA-1 hash of a string
Calculate the SHA-256 hash of a string
Calculate the SHA-512 hash of a string
Determine the sign of a numeric value (-1, 0, or 1)
Calculate the sine of a numeric value specified in radians
Calculate the hyperbolic sine of a numeric value
Return the seconds remaining until an SLA breaches
Split a string into an array
Calculate the square root of a numeric value
Compute the population standard deviation of a numeric field within the comp stage
Compute the population standard deviation of a numeric field over a window of rows within the windowcomp stage
Compute the sample standard deviation of a numeric field within the comp stage
Compute the sample standard deviation of a numeric field over a window of rows within the windowcomp stage
Count occurrences of a substring in a string
Subtract one number from another
Compute the sum of a numeric field within the comp stage
Compute the sum of a numeric field over a window of rows within the windowcomp stage
Calculate the tangent of a numeric value specified in radians
Calculate the hyperbolic tangent of a numeric value
Return the end of a time frame
Calculate the difference between two timestamps
Convert a timestamp to seconds
Convert a value to a boolean
Convert a timestamp to an epoch value
Convert a value to a float
Convert a value to an integer
Convert a value to a JSON string
Convert a value to a number
Convert a value to a string
Convert a value to a timestamp
Remove leading and trailing whitespace from a string
Truncate a numeric value to a specified number of decimal places
Convert a string to uppercase
Collect all distinct values of a field and return them as an array within the comp stage
Compute the variance of a numeric field within the comp stage
Check if a string matches a wildcard pattern
Last updated
Was this helpful?
