Built-in Functions → Miscellaneous Functions

The following table lists various functions for finding values in table hierarchies, identifying a schema's last refresh time, and determining the row number in a query:

FunctionSignatureDescription
descendantOf()descendantOf(field, value)Returns true for each record that is descendant of a named parent
descendantOf()descendantOf(field, value, depth)Returns true for each record that is descendant of a named parent down to a specified depth level
lookup()lookup(result, key, value)Returns a value from a table using primary key values.
schemaRefreshTime()schemaRefreshTime(schema)Returns the last refresh start time if the system is running
rowNumber()rowNumber()Returns a sequential number of a row within an insight result set