Skip to main content

Released Functions

abs​

abs(number: Number[1]): Number[1]

  • Parameters

    • number: Number[1]

  • Returns

    • Number[1]
abs(int: Integer[1]): Integer[1]

  • Parameters

    • int: Integer[1]

  • Returns

    • Integer[1]
  • Usage
{|Person->getAll()->project({p|$p.firstName}, 'firstName')->groupBy('firstName', 'new'->agg({e|$e}, {y|$y->count()->abs()}))}
abs(float: Float[1]): Float[1]

  • Parameters

    • float: Float[1]

  • Returns

    • Float[1]
abs(decimal: Decimal[1]): Decimal[1]

  • Parameters

    • decimal: Decimal[1]

  • Returns

    • Decimal[1]

add​

add<T>(set: T[*], val: T[1]): T[1..*]

  • Parameters

    • set: T[*]
    • val: T[1]

  • Returns

    • T[1..*]

adjust​

adjust(date: Date[1], number: Integer[1], unit: DurationUnit[1]): Date[1]

  • Parameters

    • date: Date[1]
    • number: Integer[1]
    • unit: DurationUnit[1]

  • Returns

    • Date[1]

and​

and(first: Boolean[1], second: Boolean[1]): Boolean[1]

  • Parameters

    • first: Boolean[1]
    • second: Boolean[1]

  • Returns

    • Boolean[1]
and(vals: Boolean[*]): Boolean[1]

  • Parameters

    • vals: Boolean[*]

  • Returns

    • Boolean[1]

assert​

assert(condition: Boolean[1], formatString: String[1], formatArgs: Any[*]): Boolean[1]

  • Parameters

    • condition: Boolean[1]
    • formatString: String[1]
    • formatArgs: Any[*]

  • Returns

    • Boolean[1]
assert(condition: Boolean[1], messageFunction: Function<{->String[1]}<[1]): Boolean[1]

  • Parameters

    • condition: Boolean[1]
    • messageFunction: Function<{->String[1]}<[1]

  • Returns

    • Boolean[1]
assert(condition: Boolean[1], message: String[1]): Boolean[1]

  • Parameters

    • condition: Boolean[1]
    • message: String[1]

  • Returns

    • Boolean[1]
assert(condition: Boolean[1]): Boolean[1]

  • Parameters

    • condition: Boolean[1]

  • Returns

    • Boolean[1]

at​

at<T>(set: T[*], key: Integer[1]): T[1]

  • Parameters

    • set: T[*]
    • key: Integer[1]

  • Returns

    • T[1]

average​

average(numbers: Float[*]): Float[1]

  • Parameters

    • numbers: Float[*]

  • Returns

    • Float[1]
average(numbers: Integer[*]): Float[1]

  • Parameters

    • numbers: Integer[*]

  • Returns

    • Float[1]
average(numbers: Number[*]): Float[1]

  • Parameters

    • numbers: Number[*]

  • Returns

    • Float[1]

cast​

cast<T>(source: Any[m], object: T[1]): T[m]

  • Parameters

    • source: Any[m]
    • object: T[1]

  • Returns

    • T[m]

ceiling​

ceiling(number: Number[1]): Integer[1]

  • Parameters

    • number: Number[1]

  • Returns

    • Integer[1]

chunk​

chunk(source: String[1], val: Integer[1]): String[*]

  • Parameters

    • source: String[1]
    • val: Integer[1]

  • Returns

    • String[*]

compare​

compare<T>(a: T[1], b: T[1]): Integer[1]

  • Parameters

    • a: T[1]
    • b: T[1]

  • Returns

    • Integer[1]

concatenate​

concatenate<T>(set1: T[*], set2: T[*]): T[*]

  • Parameters

    • set1: T[*]
    • set2: T[*]

  • Returns

    • T[*]

contains​

contains(collection: Any[*], value: Any[1]): Boolean[1]

  • Parameters

    • collection: Any[*]
    • value: Any[1]

  • Returns

    • Boolean[1]
contains(source: String[1], val: String[1]): Boolean[1]

  • Parameters

    • source: String[1]
    • val: String[1]

  • Returns

    • Boolean[1]

convert​

convert(unit: Any[1], targetUnit: Unit[1]): Any[1]

  • Parameters

    • unit: Any[1]
    • targetUnit: Unit[1]

  • Returns

    • Any[1]

cos​

cos(number: Number[1]): Float[1]

  • Parameters

    • number: Number[1]

  • Returns

    • Float[1]

count​

count(s: Any[*]): Integer[1]

  • Parameters

    • s: Any[*]

  • Returns

    • Integer[1]

date​

date(year: Integer[1], month: Integer[1], day: Integer[1], hour: Integer[1]): DateTime[1]

  • Parameters

    • year: Integer[1]
    • month: Integer[1]
    • day: Integer[1]
    • hour: Integer[1]

  • Returns

    • DateTime[1]
date(year: Integer[1], month: Integer[1], day: Integer[1]): StrictDate[1]

  • Parameters

    • year: Integer[1]
    • month: Integer[1]
    • day: Integer[1]

  • Returns

    • StrictDate[1]
date(year: Integer[1]): Date[1]

  • Parameters

    • year: Integer[1]

  • Returns

    • Date[1]
date(year: Integer[1], month: Integer[1]): Date[1]

  • Parameters

    • year: Integer[1]
    • month: Integer[1]

  • Returns

    • Date[1]
date(year: Integer[1], month: Integer[1], day: Integer[1], hour: Integer[1], minute: Integer[1]): DateTime[1]

  • Parameters

    • year: Integer[1]
    • month: Integer[1]
    • day: Integer[1]
    • hour: Integer[1]
    • minute: Integer[1]

  • Returns

    • DateTime[1]
date(year: Integer[1], month: Integer[1], day: Integer[1], hour: Integer[1], minute: Integer[1], second: Number[1]): DateTime[1]

  • Parameters

    • year: Integer[1]
    • month: Integer[1]
    • day: Integer[1]
    • hour: Integer[1]
    • minute: Integer[1]
    • second: Number[1]

  • Returns

    • DateTime[1]

dateDiff​

dateDiff(d1: Date[1], d2: Date[1], du: DurationUnit[1]): Integer[1]

  • Parameters

    • d1: Date[1]
    • d2: Date[1]
    • du: DurationUnit[1]

  • Returns

    • Integer[1]

datePart​

datePart(d: Date[1]): Date[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Date[1]

dayOfMonth​

dayOfMonth(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

dayOfWeekNumber​

dayOfWeekNumber(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

distinct​

distinct<T>(s: T[*]): T[*]

  • Parameters

    • s: T[*]

  • Returns

    • T[*]

divide​

divide(left: Number[1], right: Number[1]): Float[1]

  • Parameters

    • left: Number[1]
    • right: Number[1]

  • Returns

    • Float[1]

drop​

drop<T>(set: T[*], count: Integer[1]): T[*]

  • Parameters

    • set: T[*]
    • count: Integer[1]

  • Returns

    • T[*]

endsWith​

endsWith(source: String[1], val: String[1]): Boolean[1]

  • Parameters

    • source: String[1]
    • val: String[1]

  • Returns

    • Boolean[1]

enumValues​

enumValues<T>(enum: Enumeration<T<[1]): T[*]

  • Parameters

    • enum: Enumeration<T<[1]

  • Returns

    • T[*]

eq​

eq(left: Any[1], right: Any[1]): Boolean[1]

  • Parameters

    • left: Any[1]
    • right: Any[1]

  • Returns

    • Boolean[1]

equal​

equal(left: Any[*], right: Any[*]): Boolean[1]

  • Parameters

    • left: Any[*]
    • right: Any[*]

  • Returns

    • Boolean[1]

exists​

exists<T>(value: T[*], func: Function<{T[1]->Boolean[1]}<[1]): Boolean[1]

  • Parameters

    • value: T[*]
    • func: Function<{T[1]->Boolean[1]}<[1]

  • Returns

    • Boolean[1]

extractEnumValue​

extractEnumValue<T>(enum: Enumeration<T<[1], value: String[1]): T[1]

  • Parameters

    • enum: Enumeration<T<[1]
    • value: String[1]

  • Returns

    • T[1]

filter​

filter<T>(value: T[*], func: Function<{T[1]->Boolean[1]}<[1]): T[*]

  • Parameters

    • value: T[*]
    • func: Function<{T[1]->Boolean[1]}<[1]

  • Returns

    • T[*]

first​

first<T>(set: T[*]): T[0..1]

  • Parameters

    • set: T[*]

  • Returns

    • T[0..1]

firstDayOfMonth​

firstDayOfMonth(date: Date[1]): Date[1]

  • Parameters

    • date: Date[1]

  • Returns

    • Date[1]

firstDayOfQuarter​

firstDayOfQuarter(date: Date[1]): StrictDate[1]

  • Parameters

    • date: Date[1]

  • Returns

    • StrictDate[1]

firstDayOfThisMonth​

firstDayOfThisMonth(): Date[1]

  • Returns

    • Date[1]

firstDayOfThisQuarter​

firstDayOfThisQuarter(): StrictDate[1]

  • Returns

    • StrictDate[1]

firstDayOfThisYear​

firstDayOfThisYear(): Date[1]

  • Returns

    • Date[1]

firstDayOfWeek​

firstDayOfWeek(date: Date[1]): Date[1]

  • Parameters

    • date: Date[1]

  • Returns

    • Date[1]

firstDayOfYear​

firstDayOfYear(date: Date[1]): Date[1]

  • Parameters

    • date: Date[1]

  • Returns

    • Date[1]

floor​

floor(number: Number[1]): Integer[1]

  • Parameters

    • number: Number[1]

  • Returns

    • Integer[1]

fold​

fold<T, V>(value: T[*], func: Function<{T[1],V[m]->V[m]}<[1], accumulator: V[m]): V[m]

  • Parameters

    • value: T[*]
    • func: Function<{T[1],V[m]->V[m]}<[1]
    • accumulator: V[m]

  • Returns

    • V[m]

forAll​

forAll<T>(value: T[*], func: Function<{T[1]->Boolean[1]}<[1]): Boolean[1]

  • Parameters

    • value: T[*]
    • func: Function<{T[1]->Boolean[1]}<[1]

  • Returns

    • Boolean[1]

format​

format(format: String[1], args: Any[*]): String[1]

  • Parameters

    • format: String[1]
    • args: Any[*]

  • Returns

    • String[1]

generateGuid​

generateGuid(): String[1]

  • Returns

    • String[1]

greaterThan​

greaterThan(left: Boolean[0..1], right: Boolean[0..1]): Boolean[1]

  • Parameters

    • left: Boolean[0..1]
    • right: Boolean[0..1]

  • Returns

    • Boolean[1]
greaterThan(left: String[1], right: String[0..1]): Boolean[1]

  • Parameters

    • left: String[1]
    • right: String[0..1]

  • Returns

    • Boolean[1]
greaterThan(left: Number[0..1], right: Number[0..1]): Boolean[1]

  • Parameters

    • left: Number[0..1]
    • right: Number[0..1]

  • Returns

    • Boolean[1]
greaterThan(left: String[1], right: String[1]): Boolean[1]

  • Parameters

    • left: String[1]
    • right: String[1]

  • Returns

    • Boolean[1]
greaterThan(left: Date[1], right: Date[1]): Boolean[1]

  • Parameters

    • left: Date[1]
    • right: Date[1]

  • Returns

    • Boolean[1]
greaterThan(left: String[0..1], right: String[1]): Boolean[1]

  • Parameters

    • left: String[0..1]
    • right: String[1]

  • Returns

    • Boolean[1]
greaterThan(left: Boolean[1], right: Boolean[0..1]): Boolean[1]

  • Parameters

    • left: Boolean[1]
    • right: Boolean[0..1]

  • Returns

    • Boolean[1]
greaterThan(left: Number[0..1], right: Number[1]): Boolean[1]

  • Parameters

    • left: Number[0..1]
    • right: Number[1]

  • Returns

    • Boolean[1]
greaterThan(left: String[0..1], right: String[0..1]): Boolean[1]

  • Parameters

    • left: String[0..1]
    • right: String[0..1]

  • Returns

    • Boolean[1]
greaterThan(left: Boolean[0..1], right: Boolean[1]): Boolean[1]

  • Parameters

    • left: Boolean[0..1]
    • right: Boolean[1]

  • Returns

    • Boolean[1]
greaterThan(left: Number[1], right: Number[0..1]): Boolean[1]

  • Parameters

    • left: Number[1]
    • right: Number[0..1]

  • Returns

    • Boolean[1]
greaterThan(left: Number[1], right: Number[1]): Boolean[1]

  • Parameters

    • left: Number[1]
    • right: Number[1]

  • Returns

    • Boolean[1]

greaterThanEqual​

greaterThanEqual(left: String[0..1], right: String[1]): Boolean[1]

  • Parameters

    • left: String[0..1]
    • right: String[1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Date[1], right: Date[0..1]): Boolean[1]

  • Parameters

    • left: Date[1]
    • right: Date[0..1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Boolean[1], right: Boolean[0..1]): Boolean[1]

  • Parameters

    • left: Boolean[1]
    • right: Boolean[0..1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Number[0..1], right: Number[0..1]): Boolean[1]

  • Parameters

    • left: Number[0..1]
    • right: Number[0..1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Number[1], right: Number[1]): Boolean[1]

  • Parameters

    • left: Number[1]
    • right: Number[1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Boolean[0..1], right: Boolean[0..1]): Boolean[1]

  • Parameters

    • left: Boolean[0..1]
    • right: Boolean[0..1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Number[1], right: Number[0..1]): Boolean[1]

  • Parameters

    • left: Number[1]
    • right: Number[0..1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Date[0..1], right: Date[1]): Boolean[1]

  • Parameters

    • left: Date[0..1]
    • right: Date[1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Date[0..1], right: Date[0..1]): Boolean[1]

  • Parameters

    • left: Date[0..1]
    • right: Date[0..1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Date[1], right: Date[1]): Boolean[1]

  • Parameters

    • left: Date[1]
    • right: Date[1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: String[0..1], right: String[0..1]): Boolean[1]

  • Parameters

    • left: String[0..1]
    • right: String[0..1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: String[1], right: String[1]): Boolean[1]

  • Parameters

    • left: String[1]
    • right: String[1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: String[1], right: String[0..1]): Boolean[1]

  • Parameters

    • left: String[1]
    • right: String[0..1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Boolean[0..1], right: Boolean[1]): Boolean[1]

  • Parameters

    • left: Boolean[0..1]
    • right: Boolean[1]

  • Returns

    • Boolean[1]
greaterThanEqual(left: Number[0..1], right: Number[1]): Boolean[1]

  • Parameters

    • left: Number[0..1]
    • right: Number[1]

  • Returns

    • Boolean[1]

hasDay​

hasDay(d: Date[1]): Boolean[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Boolean[1]

hasHour​

hasHour(d: Date[1]): Boolean[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Boolean[1]

hasMinute​

hasMinute(d: Date[1]): Boolean[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Boolean[1]

hasMonth​

hasMonth(d: Date[1]): Boolean[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Boolean[1]

hasSecond​

hasSecond(d: Date[1]): Boolean[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Boolean[1]

hasSubsecond​

hasSubsecond(d: Date[1]): Boolean[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Boolean[1]

hasSubsecondWithAtLeastPrecision​

hasSubsecondWithAtLeastPrecision(d: Date[1], minPrecision: Integer[1]): Boolean[1]

  • Parameters

    • d: Date[1]
    • minPrecision: Integer[1]

  • Returns

    • Boolean[1]

hasYear​

hasYear(d: Date[1]): Boolean[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Boolean[1]

hour​

hour(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

id​

id(instance: Any[1]): String[1]

  • Parameters

    • instance: Any[1]

  • Returns

    • String[1]

if​

if<T>(test: Boolean[1], valid: Function<{->T[m]}<[1], invalid: Function<{->T[m]}<[1]): T[m]

  • Parameters

    • test: Boolean[1]
    • valid: Function<{->T[m]}<[1]
    • invalid: Function<{->T[m]}<[1]

  • Returns

    • T[m]

in​

in(value: Any[1], collection: Any[*]): Boolean[1]

  • Parameters

    • value: Any[1]
    • collection: Any[*]

  • Returns

    • Boolean[1]
in(value: Any[0..1], collection: Any[*]): Boolean[1]

  • Parameters

    • value: Any[0..1]
    • collection: Any[*]

  • Returns

    • Boolean[1]

indexOf​

indexOf<T>(set: T[*], value: T[1]): Integer[1]

  • Parameters

    • set: T[*]
    • value: T[1]

  • Returns

    • Integer[1]
indexOf(str: String[1], toFind: String[1], fromIndex: Integer[1]): Integer[1]

  • Parameters

    • str: String[1]
    • toFind: String[1]
    • fromIndex: Integer[1]

  • Returns

    • Integer[1]
indexOf(str: String[1], toFind: String[1]): Integer[1]

  • Parameters

    • str: String[1]
    • toFind: String[1]

  • Returns

    • Integer[1]

init​

init<T>(set: T[*]): T[*]

  • Parameters

    • set: T[*]

  • Returns

    • T[*]

instanceOf​

instanceOf(instance: Any[1], type: Type[1]): Boolean[1]

  • Parameters

    • instance: Any[1]
    • type: Type[1]

  • Returns

    • Boolean[1]

is​

is(left: Any[1], right: Any[1]): Boolean[1]

  • Parameters

    • left: Any[1]
    • right: Any[1]

  • Returns

    • Boolean[1]

isDistinct​

isDistinct<T>(collection: T[*], graphFetchTree: RootGraphFetchTree<T<[1]): Boolean[1]

  • Parameters

    • collection: T[*]
    • graphFetchTree: RootGraphFetchTree<T<[1]

  • Returns

    • Boolean[1]
isDistinct<T>(set: T[*]): Boolean[1]

  • Parameters

    • set: T[*]

  • Returns

    • Boolean[1]

isEmpty​

isEmpty(p: Any[0..1]): Boolean[1]

  • Parameters

    • p: Any[0..1]

  • Returns

    • Boolean[1]
isEmpty(p: Any[*]): Boolean[1]

  • Parameters

    • p: Any[*]

  • Returns

    • Boolean[1]

isEqual​

isEqual<T>(c1: T[1], c2: T[1], graphFetchTree: RootGraphFetchTree<T<[1]): Boolean[1]

  • Parameters

    • c1: T[1]
    • c2: T[1]
    • graphFetchTree: RootGraphFetchTree<T<[1]

  • Returns

    • Boolean[1]

isNotEmpty​

isNotEmpty(p: Any[*]): Boolean[1]

  • Parameters

    • p: Any[*]

  • Returns

    • Boolean[1]
isNotEmpty(p: Any[0..1]): Boolean[1]

  • Parameters

    • p: Any[0..1]

  • Returns

    • Boolean[1]

joinStrings​

joinStrings(strings: String[*], prefix: String[1], separator: String[1], suffix: String[1]): String[1]

  • Parameters

    • strings: String[*]
    • prefix: String[1]
    • separator: String[1]
    • suffix: String[1]

  • Returns

    • String[1]
joinStrings(strings: String[*], separator: String[1]): String[1]

  • Parameters

    • strings: String[*]
    • separator: String[1]

  • Returns

    • String[1]
  • Usage
{|Firm->getAll()->groupBy({f|$f.legalName}, {x|$x.employees->map({v_automap|$v_automap.firstName})}->agg({y|$y->joinStrings('*')}), ['legalName', 'employeesFirstName'])}
joinStrings(strings: String[*]): String[1]

  • Parameters

    • strings: String[*]

  • Returns

    • String[1]

last​

last<T>(set: T[*]): T[0..1]

  • Parameters

    • set: T[*]

  • Returns

    • T[0..1]

length​

length(str: String[1]): Integer[1]

  • Parameters

    • str: String[1]

  • Returns

    • Integer[1]

lessThan​

lessThan(left: Number[0..1], right: Number[0..1]): Boolean[1]

  • Parameters

    • left: Number[0..1]
    • right: Number[0..1]

  • Returns

    • Boolean[1]
lessThan(left: Boolean[0..1], right: Boolean[1]): Boolean[1]

  • Parameters

    • left: Boolean[0..1]
    • right: Boolean[1]

  • Returns

    • Boolean[1]
lessThan(left: Boolean[0..1], right: Boolean[0..1]): Boolean[1]

  • Parameters

    • left: Boolean[0..1]
    • right: Boolean[0..1]

  • Returns

    • Boolean[1]
lessThan(left: String[0..1], right: String[0..1]): Boolean[1]

  • Parameters

    • left: String[0..1]
    • right: String[0..1]

  • Returns

    • Boolean[1]
lessThan(left: String[1], right: String[0..1]): Boolean[1]

  • Parameters

    • left: String[1]
    • right: String[0..1]

  • Returns

    • Boolean[1]
lessThan(left: String[0..1], right: String[1]): Boolean[1]

  • Parameters

    • left: String[0..1]
    • right: String[1]

  • Returns

    • Boolean[1]
lessThan(left: Boolean[1], right: Boolean[0..1]): Boolean[1]

  • Parameters

    • left: Boolean[1]
    • right: Boolean[0..1]

  • Returns

    • Boolean[1]
lessThan(left: Date[1], right: Date[1]): Boolean[1]

  • Parameters

    • left: Date[1]
    • right: Date[1]

  • Returns

    • Boolean[1]
lessThan(left: Number[0..1], right: Number[1]): Boolean[1]

  • Parameters

    • left: Number[0..1]
    • right: Number[1]

  • Returns

    • Boolean[1]
lessThan(left: Number[1], right: Number[0..1]): Boolean[1]

  • Parameters

    • left: Number[1]
    • right: Number[0..1]

  • Returns

    • Boolean[1]
lessThan(left: String[1], right: String[1]): Boolean[1]

  • Parameters

    • left: String[1]
    • right: String[1]

  • Returns

    • Boolean[1]
lessThan(left: Number[1], right: Number[1]): Boolean[1]

  • Parameters

    • left: Number[1]
    • right: Number[1]

  • Returns

    • Boolean[1]

lessThanEqual​

lessThanEqual(left: Date[1], right: Date[0..1]): Boolean[1]

  • Parameters

    • left: Date[1]
    • right: Date[0..1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Number[1], right: Number[1]): Boolean[1]

  • Parameters

    • left: Number[1]
    • right: Number[1]

  • Returns

    • Boolean[1]
lessThanEqual(left: String[1], right: String[1]): Boolean[1]

  • Parameters

    • left: String[1]
    • right: String[1]

  • Returns

    • Boolean[1]
lessThanEqual(left: String[1], right: String[0..1]): Boolean[1]

  • Parameters

    • left: String[1]
    • right: String[0..1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Date[0..1], right: Date[0..1]): Boolean[1]

  • Parameters

    • left: Date[0..1]
    • right: Date[0..1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Number[0..1], right: Number[1]): Boolean[1]

  • Parameters

    • left: Number[0..1]
    • right: Number[1]

  • Returns

    • Boolean[1]
lessThanEqual(left: String[0..1], right: String[1]): Boolean[1]

  • Parameters

    • left: String[0..1]
    • right: String[1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Date[0..1], right: Date[1]): Boolean[1]

  • Parameters

    • left: Date[0..1]
    • right: Date[1]

  • Returns

    • Boolean[1]
lessThanEqual(left: String[0..1], right: String[0..1]): Boolean[1]

  • Parameters

    • left: String[0..1]
    • right: String[0..1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Number[1], right: Number[0..1]): Boolean[1]

  • Parameters

    • left: Number[1]
    • right: Number[0..1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Number[0..1], right: Number[0..1]): Boolean[1]

  • Parameters

    • left: Number[0..1]
    • right: Number[0..1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Date[1], right: Date[1]): Boolean[1]

  • Parameters

    • left: Date[1]
    • right: Date[1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Boolean[0..1], right: Boolean[1]): Boolean[1]

  • Parameters

    • left: Boolean[0..1]
    • right: Boolean[1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Boolean[0..1], right: Boolean[0..1]): Boolean[1]

  • Parameters

    • left: Boolean[0..1]
    • right: Boolean[0..1]

  • Returns

    • Boolean[1]
lessThanEqual(left: Boolean[1], right: Boolean[0..1]): Boolean[1]

  • Parameters

    • left: Boolean[1]
    • right: Boolean[0..1]

  • Returns

    • Boolean[1]

letFunction​

letFunction<T>(left: String[1], right: T[m]): T[m]

  • Parameters

    • left: String[1]
    • right: T[m]

  • Returns

    • T[m]

limit​

limit<T>(set: T[*], count: Integer[1]): T[*]

  • Parameters

    • set: T[*]
    • count: Integer[1]

  • Returns

    • T[*]

map​

map<T, V>(value: T[*], func: Function<{T[1]->V[*]}<[1]): V[*]

  • Parameters

    • value: T[*]
    • func: Function<{T[1]->V[*]}<[1]

  • Returns

    • V[*]
map<T, V>(value: T[0..1], func: Function<{T[1]->V[0..1]}<[1]): V[0..1]

  • Parameters

    • value: T[0..1]
    • func: Function<{T[1]->V[0..1]}<[1]

  • Returns

    • V[0..1]
map<T, V>(value: T[m], func: Function<{T[1]->V[1]}<[1]): V[m]

  • Parameters

    • value: T[m]
    • func: Function<{T[1]->V[1]}<[1]

  • Returns

    • V[m]

match​

match<T>(var: Any[*], functions: Function<{Nil[n]->T[m]}<[1..*]): T[m]

  • Parameters

    • var: Any[*]
    • functions: Function<{Nil[n]->T[m]}<[1..*]

  • Returns

    • T[m]

matches​

matches(string: String[1], regexp: String[1]): Boolean[1]

  • Parameters

    • string: String[1]
    • regexp: String[1]

  • Returns

    • Boolean[1]

max​

max(ints: Float[1..*]): Float[1]

  • Parameters

    • ints: Float[1..*]

  • Returns

    • Float[1]
max(numbers: Number[1..*]): Number[1]

  • Parameters

    • numbers: Number[1..*]

  • Returns

    • Number[1]
max(ints: Integer[1..*]): Integer[1]

  • Parameters

    • ints: Integer[1..*]

  • Returns

    • Integer[1]
max(left: Number[1], right: Number[1]): Number[1]

  • Parameters

    • left: Number[1]
    • right: Number[1]

  • Returns

    • Number[1]
max(ints: Integer[*]): Integer[0..1]

  • Parameters

    • ints: Integer[*]

  • Returns

    • Integer[0..1]
max(numbers: Number[*]): Number[0..1]

  • Parameters

    • numbers: Number[*]

  • Returns

    • Number[0..1]
max(ints: Float[*]): Float[0..1]

  • Parameters

    • ints: Float[*]

  • Returns

    • Float[0..1]

min​

min(ints: Integer[*]): Integer[0..1]

  • Parameters

    • ints: Integer[*]

  • Returns

    • Integer[0..1]
min(left: Number[1], right: Number[1]): Number[1]

  • Parameters

    • left: Number[1]
    • right: Number[1]

  • Returns

    • Number[1]
min(ints: Float[1..*]): Float[1]

  • Parameters

    • ints: Float[1..*]

  • Returns

    • Float[1]
min(numbers: Number[*]): Number[0..1]

  • Parameters

    • numbers: Number[*]

  • Returns

    • Number[0..1]
min(ints: Integer[1..*]): Integer[1]

  • Parameters

    • ints: Integer[1..*]

  • Returns

    • Integer[1]
min(ints: Float[*]): Float[0..1]

  • Parameters

    • ints: Float[*]

  • Returns

    • Float[0..1]
min(numbers: Number[1..*]): Number[1]

  • Parameters

    • numbers: Number[1..*]

  • Returns

    • Number[1]

minus​

minus(ints: Integer[*]): Integer[1]

  • Parameters

    • ints: Integer[*]

  • Returns

    • Integer[1]
minus(float: Float[*]): Float[1]

  • Parameters

    • float: Float[*]

  • Returns

    • Float[1]
minus(decimal: Decimal[*]): Decimal[1]

  • Parameters

    • decimal: Decimal[*]

  • Returns

    • Decimal[1]
minus(numbers: Number[*]): Number[1]

  • Parameters

    • numbers: Number[*]

  • Returns

    • Number[1]

minute​

minute(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

monthNumber​

monthNumber(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

mostRecentDayOfWeek​

Returns the most recent instance of the given day of the week that is no later than the given date.
mostRecentDayOfWeek(date: Date[1], day: DayOfWeek[1]): Date[1]

  • Parameters

    • date: Date[1]
    • day: DayOfWeek[1]

  • Returns

    • Date[1]
Returns the most recent instance of the given day of the week that is no later than today.
mostRecentDayOfWeek(day: DayOfWeek[1]): Date[1]

  • Parameters

    • day: DayOfWeek[1]

  • Returns

    • Date[1]

new​

new<T>(class: Class<T<[1], id: String[1], keyExpressions: KeyExpression[*]): T[1]

  • Parameters

    • class: Class<T<[1]
    • id: String[1]
    • keyExpressions: KeyExpression[*]

  • Returns

    • T[1]

newUnit​

newUnit(type: Unit[1], value: Number[1]): Any[1]

  • Parameters

    • type: Unit[1]
    • value: Number[1]

  • Returns

    • Any[1]

not​

not(bool: Boolean[1]): Boolean[1]

  • Parameters

    • bool: Boolean[1]

  • Returns

    • Boolean[1]

now​

now(): DateTime[1]

  • Returns

    • DateTime[1]

or​

or(first: Boolean[1], second: Boolean[1]): Boolean[1]

  • Parameters

    • first: Boolean[1]
    • second: Boolean[1]

  • Returns

    • Boolean[1]
or(vals: Boolean[1..*]): Boolean[1]

  • Parameters

    • vals: Boolean[1..*]

  • Returns

    • Boolean[1]

orElse​

orElse<T>(maybe: T[0..1], dflt: T[1]): T[1]

  • Parameters

    • maybe: T[0..1]
    • dflt: T[1]

  • Returns

    • T[1]

parseBoolean​

parseBoolean(string: String[1]): Boolean[1]

  • Parameters

    • string: String[1]

  • Returns

    • Boolean[1]

parseDate​

parseDate(string: String[1]): Date[1]

  • Parameters

    • string: String[1]

  • Returns

    • Date[1]

parseDecimal​

parseDecimal(string: String[1]): Decimal[1]

  • Parameters

    • string: String[1]

  • Returns

    • Decimal[1]

parseFloat​

parseFloat(string: String[1]): Float[1]

  • Parameters

    • string: String[1]

  • Returns

    • Float[1]

parseInteger​

parseInteger(string: String[1]): Integer[1]

  • Parameters

    • string: String[1]

  • Returns

    • Integer[1]

plus​

plus(ints: Integer[*]): Integer[1]

  • Parameters

    • ints: Integer[*]

  • Returns

    • Integer[1]
plus(decimal: Decimal[*]): Decimal[1]

  • Parameters

    • decimal: Decimal[*]

  • Returns

    • Decimal[1]
plus(numbers: Number[*]): Number[1]

  • Parameters

    • numbers: Number[*]

  • Returns

    • Number[1]
plus(float: Float[*]): Float[1]

  • Parameters

    • float: Float[*]

  • Returns

    • Float[1]
plus(strings: String[*]): String[1]

  • Parameters

    • strings: String[*]

  • Returns

    • String[1]

previousDayOfWeek​

Returns the most recent instance of the given day of the week that is strictly before today.
previousDayOfWeek(day: DayOfWeek[1]): Date[1]

  • Parameters

    • day: DayOfWeek[1]

  • Returns

    • Date[1]
Returns the most recent instance of the given day of the week that is strictly before the given date.
previousDayOfWeek(date: Date[1], day: DayOfWeek[1]): Date[1]

  • Parameters

    • date: Date[1]
    • day: DayOfWeek[1]

  • Returns

    • Date[1]

quarterNumber​

quarterNumber(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

range​

range(stop: Integer[1]): Integer[*]

  • Parameters

    • stop: Integer[1]

  • Returns

    • Integer[*]
range(start: Integer[1], stop: Integer[1], step: Integer[1]): Integer[*]

  • Parameters

    • start: Integer[1]
    • stop: Integer[1]
    • step: Integer[1]

  • Returns

    • Integer[*]
range(start: Integer[1], stop: Integer[1]): Integer[*]

  • Parameters

    • start: Integer[1]
    • stop: Integer[1]

  • Returns

    • Integer[*]

rem​

rem(dividend: Number[1], divisor: Number[1]): Number[1]

  • Parameters

    • dividend: Number[1]
    • divisor: Number[1]

  • Returns

    • Number[1]

removeDuplicates​

removeDuplicates<T>(col: T[*]): T[*]

  • Parameters

    • col: T[*]

  • Returns

    • T[*]
removeDuplicates<T, V>(col: T[*], key: Function<{T[1]->V[1]}<[0..1], eql: Function<{V[1],V[1]->Boolean[1]}<[0..1]): T[*]

  • Parameters

    • col: T[*]
    • key: Function<{T[1]->V[1]}<[0..1]
    • eql: Function<{V[1],V[1]->Boolean[1]}<[0..1]

  • Returns

    • T[*]
removeDuplicates<T>(col: T[*], eql: Function<{T[1],T[1]->Boolean[1]}<[1]): T[*]

  • Parameters

    • col: T[*]
    • eql: Function<{T[1],T[1]->Boolean[1]}<[1]

  • Returns

    • T[*]

removeDuplicatesBy​

removeDuplicatesBy<T>(col: T[*], key: Function<{T[1]->Any[1]}<[1]): T[*]

  • Parameters

    • col: T[*]
    • key: Function<{T[1]->Any[1]}<[1]

  • Returns

    • T[*]

replace​

replace(source: String[1], toReplace: String[1], replacement: String[1]): String[1]

  • Parameters

    • source: String[1]
    • toReplace: String[1]
    • replacement: String[1]

  • Returns

    • String[1]

reverse​

reverse<T>(set: T[m]): T[m]

  • Parameters

    • set: T[m]

  • Returns

    • T[m]

round​

round(decimal: Decimal[1], scale: Integer[1]): Decimal[1]

  • Parameters

    • decimal: Decimal[1]
    • scale: Integer[1]

  • Returns

    • Decimal[1]
round(number: Number[1]): Integer[1]

  • Parameters

    • number: Number[1]

  • Returns

    • Integer[1]

second​

second(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

sin​

sin(number: Number[1]): Float[1]

  • Parameters

    • number: Number[1]

  • Returns

    • Float[1]

size​

size(p: Any[*]): Integer[1]

  • Parameters

    • p: Any[*]

  • Returns

    • Integer[1]

slice​

slice<T>(set: T[*], start: Integer[1], end: Integer[1]): T[*]

  • Parameters

    • set: T[*]
    • start: Integer[1]
    • end: Integer[1]

  • Returns

    • T[*]

sort​

sort<T>(col: T[m]): T[m]

  • Parameters

    • col: T[m]

  • Returns

    • T[m]
sort<T>(col: T[m], comp: Function<{T[1],T[1]->Integer[1]}<[0..1]): T[m]

  • Parameters

    • col: T[m]
    • comp: Function<{T[1],T[1]->Integer[1]}<[0..1]

  • Returns

    • T[m]
sort<T, U>(col: T[m], key: Function<{T[1]->U[1]}<[0..1], comp: Function<{U[1],U[1]->Integer[1]}<[0..1]): T[m]

  • Parameters

    • col: T[m]
    • key: Function<{T[1]->U[1]}<[0..1]
    • comp: Function<{U[1],U[1]->Integer[1]}<[0..1]

  • Returns

    • T[m]

sortBy​

sortBy<T, U>(col: T[m], key: Function<{T[1]->U[1]}<[0..1]): T[m]

  • Parameters

    • col: T[m]
    • key: Function<{T[1]->U[1]}<[0..1]

  • Returns

    • T[m]

split​

split(str: String[1], token: String[1]): String[*]

  • Parameters

    • str: String[1]
    • token: String[1]

  • Returns

    • String[*]

startsWith​

startsWith(source: String[1], val: String[1]): Boolean[1]

  • Parameters

    • source: String[1]
    • val: String[1]

  • Returns

    • Boolean[1]
  • Usage
{|Person->getAll()->project({a|$a.firstName->startsWith('tri')}, 'a')}

substring​

substring(str: String[1], start: Integer[1]): String[1]

  • Parameters

    • str: String[1]
    • start: Integer[1]

  • Returns

    • String[1]
substring(str: String[1], start: Integer[1], end: Integer[1]): String[1]

  • Parameters

    • str: String[1]
    • start: Integer[1]
    • end: Integer[1]

  • Returns

    • String[1]

tail​

tail<T>(set: T[*]): T[*]

  • Parameters

    • set: T[*]

  • Returns

    • T[*]

take​

take<T>(set: T[*], count: Integer[1]): T[*]

  • Parameters

    • set: T[*]
    • count: Integer[1]

  • Returns

    • T[*]

times​

times(decimal: Decimal[*]): Decimal[1]

  • Parameters

    • decimal: Decimal[*]

  • Returns

    • Decimal[1]
times(ints: Integer[*]): Integer[1]

  • Parameters

    • ints: Integer[*]

  • Returns

    • Integer[1]
times(ints: Float[*]): Float[1]

  • Parameters

    • ints: Float[*]

  • Returns

    • Float[1]
times(numbers: Number[*]): Number[1]

  • Parameters

    • numbers: Number[*]

  • Returns

    • Number[1]

toDecimal​

toDecimal(number: Number[1]): Decimal[1]

  • Parameters

    • number: Number[1]

  • Returns

    • Decimal[1]

toFloat​

toFloat(number: Number[1]): Float[1]

  • Parameters

    • number: Number[1]

  • Returns

    • Float[1]

toLower​

toLower(source: String[1]): String[1]

  • Parameters

    • source: String[1]

  • Returns

    • String[1]

toOne​

toOne<T>(values: T[*]): T[1]

  • Parameters

    • values: T[*]

  • Returns

    • T[1]

toOneMany​

toOneMany<T>(values: T[*]): T[1..*]

  • Parameters

    • values: T[*]

  • Returns

    • T[1..*]

toRepresentation​

toRepresentation(any: Any[1]): String[1]

  • Parameters

    • any: Any[1]

  • Returns

    • String[1]

toString​

toString(any: Any[1]): String[1]

  • Parameters

    • any: Any[1]

  • Returns

    • String[1]

toUpper​

toUpper(source: String[1]): String[1]

  • Parameters

    • source: String[1]

  • Returns

    • String[1]

toUpperFirstCharacter​

Upper cases the first charater of the provided string
toUpperFirstCharacter(values: String[*]): String[*]

  • Parameters

    • values: String[*]

  • Returns

    • String[*]

today​

today(): StrictDate[1]

  • Returns

    • StrictDate[1]
  • Usage
{|Trade->getAll()->filter({t|$t.settlementDateTime->datePart() == today()})->project({t|$t.id}, 'tradeId')}

trim​

trim(str: String[1]): String[1]

  • Parameters

    • str: String[1]

  • Returns

    • String[1]

union​

union<T>(set1: T[*], set2: T[*]): T[*]

  • Parameters

    • set1: T[*]
    • set2: T[*]

  • Returns

    • T[*]

unitType​

unitType(unit: Any[1]): String[1]

  • Parameters

    • unit: Any[1]

  • Returns

    • String[1]

unitValue​

unitValue(unit: Any[1]): Number[1]

  • Parameters

    • unit: Any[1]

  • Returns

    • Number[1]

weekOfYear​

weekOfYear(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

whenSubType​

whenSubType<T>(source: Any[*], object: T[1]): T[*]

  • Parameters

    • source: Any[*]
    • object: T[1]

  • Returns

    • T[*]
whenSubType<T>(source: Any[1], object: T[1]): T[0..1]

  • Parameters

    • source: Any[1]
    • object: T[1]

  • Returns

    • T[0..1]
whenSubType<T>(source: Any[0..1], object: T[1]): T[0..1]

  • Parameters

    • source: Any[0..1]
    • object: T[1]

  • Returns

    • T[0..1]

year​

year(d: Date[1]): Integer[1]

  • Parameters

    • d: Date[1]

  • Returns

    • Integer[1]

More​