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 |