1. Home
  2. Other Releases
  3. Cloud
  4. Guides
  5. Tours
  6. Concepts
  7. Tools
  8. 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
  9. Integrations
  10. Data applications
  11. 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