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:
Function | Signature | 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 |