1. Home
  2. Guides
  3. Concepts
  4. Tools
  5. References
    1. Apache Spark
    2. 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
      11. Query Functions
    3. Incorta Component SDK
    4. Incorta Connector SDK
    5. Connectors
    6. Copilot
    7. Data Studio
    8. Public API
    9. Security
    10. SQL Interface
    11. Visualizations
    12. Other
  6. Integrations
  7. Data applications
  8. Release Notes
  9. Incorta Premium

Built-in Functions → Filter Functions

These functions are used to filter data to those items before or after a specified date. It is also possible to filter the data in groups.

FunctionSignatureDescription
firstVersion()firstVersion(<type> value, <type> group_by, date order_by)Returns the first occurrence of a value with respect to a order_by
lastVersion()lastVersion(<type> value, <type> group_by, date order_by)Returns the last occurrence of a value with respect to a order_by