1. Home
  2. On-premises 5.2
  3. Guides
  4. Tours
  5. Concepts
  6. Tools
  7. References
    1. Apache Spark
    2. Connectors
    3. 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
    4. Incorta Connector SDK
    5. Security
    6. Visualizations
    7. Other
  8. Integrations
  9. Data applications
  10. Releases

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