Miscellaneous Functions

Function Syntax Description
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