1. Home
  2. Cloud
  3. Guides
  4. Tours
  5. Concepts
  6. Tools
  7. References
    1. Built-in Functions
      1. Aggregation Functions
      2. Analytic Functions
      3. Boolean Functions
      4. Conditional Statements
      5. Conversion Functions
      6. Filter Functions
      7. Miscellaneous Functions
      8. Arithmetic Functions
      9. Date Functions
      10. String Functions
    2. Incorta Component SDK
    3. Incorta Connector SDK
    4. Connectors
    5. Public API
    6. Security
    7. Visualizations
    8. SQL Interface
    9. Other
  8. Integrations
  9. Data applications
  10. Releases

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