› Expression editor › Functions for OData-based records

Functions for OData-based records

The IF-THEN-ELSE function is supported only with OData version 4.0.1.

In a filter condition, Insight maps the following functions to the OData standard functions.

String functions:

  • CONCAT

  • CONTAINS

  • POSITION_OF_SUBSTRING (OData function: indexof)

  • LENGTH

  • SUBSTR

  • LOWER

  • UPPER

  • TRIM

  • LIKE_PREDICATE (OData function: matchesPattern)

Datetime functions:

  • CURRENT_DATETIME

  • GET_YEAR

  • GET_MONTH

  • GET_DAY

  • GET_HOUR

  • GET_MINUTE

  • GET_SECOND

Math functions:

  • CEIL

  • FLOOR

  • ROUND

Convert functions:

  • CAST

  • CONVERT

  • TO_CHAR

  • TO_DATE

  • TO_FLOAT

  • TO_INT

Geometry functions:

  • Geometry_Intersects