Miscellaneous Functions

Function Syntax Description
descendantOf() descendantOf(field, value, [int depth]) Returns true for each record that is descendant of a named parent
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

© Incorta, Inc. All Rights Reserved.