Custom Functions

Generic functions

• agg(array)

  • agg(array).count(): int

  • agg(array).sumBy(path): int

  • agg(array).findOneByEq(path, value): string

  • agg(array).matchLabel(key, value): bool

• ends_with(string, endsWith): bool

• starts_with(string, startsWith): bool

• lower(string): string

Numeric functions

• round_down(value): int

• round_up(value): int

Date functions

• to_date(string): date

• day(date): string

• day_of_month(date): int

• month(date): string

• is_after(valueDate, afterDate): bool

• is_before(valueDate, beforeDate): bool

• is_between(valueDate, beforeDate, afterDate): bool

• is_not_between(valueDate, beforeDate, afterDate): bool

• is_time_between(valueDate, beforeDate, afterDate): bool

• timestamp(date): int

• add_days_to_date(datetime, numberOfDays): date

• add_months_to_date(datetime, numberOfMonths): date

• add_years_to_date(datetime, numberOfYears): date

---

To find out more, please refer to the articles below:

Expression Examples

Sample Use Cases