Skip to main content

Upcoming Functions

acos​

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

  • Parameters

    • number: Number[1]

  • Returns

    • Float[1]

asin​

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

  • Parameters

    • number: Number[1]

  • Returns

    • Float[1]

atan​

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

  • Parameters

    • number: Number[1]

  • Returns

    • Float[1]

atan2​

atan2(number1: Number[1], number2: Number[1]): Float[1]

  • Parameters

    • number1: Number[1]
    • number2: Number[1]

  • Returns

    • Float[1]

columnProjectionsFromRoot​

columnProjectionsFromRoot(a: Any[*], relation: NamedRelation[1], columnNames: String[*], distinct: Boolean[0..1], limit: Integer[0..1]): RelationData[1]

  • Parameters

    • a: Any[*]
    • relation: NamedRelation[1]
    • columnNames: String[*]
    • distinct: Boolean[0..1]
    • limit: Integer[0..1]

  • Returns

    • RelationData[1]

concatenate​

Append the rows from the second TDS to the rows in the first TDS. N.B. The column must be the same for the two input TDSs
concatenate(tds1: TabularDataSet[1], tds2: TabularDataSet[1]): TabularDataSet[1]

  • Parameters

    • tds1: TabularDataSet[1]
    • tds2: TabularDataSet[1]

  • Returns

    • TabularDataSet[1]

distinct​

Remove duplicate rows from the priovded TDS
distinct(tds: TabularDataSet[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]

  • Returns

    • TabularDataSet[1]

drop​

Reduce the number of rows in the provided TDS, dropping the first set of rows based on the specified size
drop(tds: TabularDataSet[1], size: Integer[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • size: Integer[1]

  • Returns

    • TabularDataSet[1]

eval​

eval<T, V>(func: Function<{"{"}T[n]->V[m]{"}"}<[1], param: T[n]): V[m]

  • Parameters

    • func: Function<{"{"}T[n]->V[m]{"}"}<[1]
    • param: T[n]

  • Returns

    • V[m]
eval<V>(func: Function<{"{"}->V[m]{"}"}<[1]): V[m]

  • Parameters

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

  • Returns

    • V[m]

exp​

exp(exponent: Number[1]): Float[1]

  • Parameters

    • exponent: Number[1]

  • Returns

    • Float[1]

extend​

Add additional new calculated columns to the provided TDS
extend(tds: TabularDataSet[1], newColumnFunctions: BasicColumnSpecification<TDSRow<[*]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • newColumnFunctions: BasicColumnSpecification<TDSRow<[*]

  • Returns

    • TabularDataSet[1]

filter​

Reduce the number of rows in the provided TDS, selecting the set of rows that match the provided filter function
filter(tds: TabularDataSet[1], f: Function<{"{"}TDSRow[1]->Boolean[1]{"}"}<[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • f: Function<{"{"}TDSRow[1]->Boolean[1]{"}"}<[1]

  • Returns

    • TabularDataSet[1]

getAll​

getAll<T>(type: Class<T<[1], processingDate: Date[1], businessDate: Date[1]): T[*]

  • Parameters

    • type: Class<T<[1]
    • processingDate: Date[1]
    • businessDate: Date[1]

  • Returns

    • T[*]
getAll<T>(type: Class<T<[1]): T[*]

  • Parameters

    • type: Class<T<[1]

  • Returns

    • T[*]
getAll<T>(type: Class<T<[1], milestoningDate: Date[1]): T[*]

  • Parameters

    • type: Class<T<[1]
    • milestoningDate: Date[1]

  • Returns

    • T[*]

getAllForEachDate​

getAllForEachDate<T>(type: Class<T<[1], dates: Date[*]): T[*]

  • Parameters

    • type: Class<T<[1]
    • dates: Date[*]

  • Returns

    • T[*]

getAllVersions​

getAllVersions<T>(type: Class<T<[1]): T[*]

  • Parameters

    • type: Class<T<[1]

  • Returns

    • T[*]

getAllVersionsInRange​

getAllVersionsInRange<T>(type: Class<T<[1], start: Date[1], end: Date[1]): T[*]

  • Parameters

    • type: Class<T<[1]
    • start: Date[1]
    • end: Date[1]

  • Returns

    • T[*]

graphFetch​

graphFetch<T>(collection: T[*], graphFetchTree: RootGraphFetchTree<T<[1], batchSize: Integer[1]): T[*]

  • Parameters

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

  • Returns

    • T[*]
graphFetch<T>(collection: T[*], graphFetchTree: RootGraphFetchTree<T<[1]): T[*]

  • Parameters

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

  • Returns

    • T[*]

graphFetchChecked​

graphFetchChecked<T>(collection: T[*], graphFetchTree: RootGraphFetchTree<T<[1]): Checked<T<[*]

  • Parameters

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

  • Returns

    • Checked<T<[*]

groupBy​

Aggregate the data within the provided TDS using the specified groupings and aggregation functions
groupBy<T, U>(tds: TabularDataSet[1], columns: String[*], aggValues: AggregateValue<T,U<[*]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • columns: String[*]
    • aggValues: AggregateValue<T,U<[*]

  • Returns

    • TabularDataSet[1]
  • Usage

{|Person->getAll()->project({p|$p.firstName}, 'firstName')->groupBy('firstName', 'new'->agg({e|$e}, {y|$y->count()}))}

groupBy<K, V, U>(set: K[*], functions: Function<{"{"}K[1]->Any[*]{"}"}<[*], aggValues: AggregateValue<K,V,U<[*], ids: String[*]): TabularDataSet[1]

  • Parameters

    • set: K[*]
    • functions: Function<{"{"}K[1]->Any[]{"}"}<[]
    • aggValues: AggregateValue<K,V,U<[*]
    • ids: String[*]

  • Returns

    • TabularDataSet[1]

groupByWithWindowSubset​

groupByWithWindowSubset<K, V, U>(set: K[*], functions: Function<{"{"}K[1]->Any[*]{"}"}<[*], aggValues: AggregateValue<K,V,U<[*], ids: String[*], subSelectIds: String[*], subAggIds: String[*]): TabularDataSet[1]

  • Parameters

    • set: K[*]
    • functions: Function<{"{"}K[1]->Any[]{"}"}<[]
    • aggValues: AggregateValue<K,V,U<[*]
    • ids: String[*]
    • subSelectIds: String[*]
    • subAggIds: String[*]

  • Returns

    • TabularDataSet[1]

isAlphaNumeric​

Return whether string non-empty and composed entirely of digits or letters.
isAlphaNumeric(string: String[1]): Boolean[1]

  • Parameters

    • string: String[1]

  • Returns

    • Boolean[1]

join​

Join the two provided TDSs using the specified join type and condition
join(tds1: TabularDataSet[1], tds2: TabularDataSet[1], type: JoinType[1], joinCondition: Function<{"{"}TDSRow[1],TDSRow[1]->Boolean[1]{"}"}<[1]): TabularDataSet[1]

  • Parameters

    • tds1: TabularDataSet[1]
    • tds2: TabularDataSet[1]
    • type: JoinType[1]
    • joinCondition: Function<{"{"}TDSRow[1],TDSRow[1]->Boolean[1]{"}"}<[1]

  • Returns

    • TabularDataSet[1]
Join the two provided TDSs using the specified join type using the specified columns as keys
join(leftTds: TabularDataSet[1], rightTds: TabularDataSet[1], type: JoinType[1], leftTdsCols: String[1..*], rightTdsCols: String[1..*]): TabularDataSet[1]

  • Parameters

    • leftTds: TabularDataSet[1]
    • rightTds: TabularDataSet[1]
    • type: JoinType[1]
    • leftTdsCols: String[1..*]
    • rightTdsCols: String[1..*]

  • Returns

    • TabularDataSet[1]

limit​

Reduce the number of rows in the provided TDS if a size is specified (otherwise returns original rows), taking the first set of rows based on the specified size
limit(tds: TabularDataSet[1], size: Integer[0..1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • size: Integer[0..1]

  • Returns

    • TabularDataSet[1]
Reduce the number of rows in the provided TDS, taking the first set of rows based on the specified size
limit(tds: TabularDataSet[1], size: Integer[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • size: Integer[1]

  • Returns

    • TabularDataSet[1]

log​

log(value: Number[1]): Float[1]

  • Parameters

    • value: Number[1]

  • Returns

    • Float[1]

max​

max(dates: Date[*]): Date[0..1]

  • Parameters

    • dates: Date[*]

  • Returns

    • Date[0..1]
max(dates: StrictDate[*]): StrictDate[0..1]

  • Parameters

    • dates: StrictDate[*]

  • Returns

    • StrictDate[0..1]

mod​

mod(dividend: Integer[1], divisor: Integer[1]): Integer[1]

  • Parameters

    • dividend: Integer[1]
    • divisor: Integer[1]

  • Returns

    • Integer[1]

objectReferenceIn​

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

  • Parameters

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

  • Returns

    • Boolean[1]

olapGroupBy​

olapGroupBy<T>(tds: TabularDataSet[1], operation: OlapOperation<T<[1], columnName: String[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • operation: OlapOperation<T<[1]
    • columnName: String[1]

  • Returns

    • TabularDataSet[1]
olapGroupBy<T>(tds: TabularDataSet[1], columns: String[*], sortBy: SortInformation[0..1], operation: OlapOperation<T<[1], columnName: String[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • columns: String[*]
    • sortBy: SortInformation[0..1]
    • operation: OlapOperation<T<[1]
    • columnName: String[1]

  • Returns

    • TabularDataSet[1]
olapGroupBy<T>(tds: TabularDataSet[1], sort: SortInformation[0..1], operation: OlapOperation<T<[1], columnName: String[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • sort: SortInformation[0..1]
    • operation: OlapOperation<T<[1]
    • columnName: String[1]

  • Returns

    • TabularDataSet[1]
olapGroupBy<T>(tds: TabularDataSet[1], columns: String[*], operation: OlapOperation<T<[1], columnName: String[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • columns: String[*]
    • operation: OlapOperation<T<[1]
    • columnName: String[1]

  • Returns

    • TabularDataSet[1]

percentile​

percentile(numbers: Number[*], percentile: Float[1], ascending: Boolean[1], continuous: Boolean[1]): Number[0..1]

  • Parameters

    • numbers: Number[*]
    • percentile: Float[1]
    • ascending: Boolean[1]
    • continuous: Boolean[1]

  • Returns

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

  • Parameters

    • numbers: Number[*]
    • percentile: Float[1]

  • Returns

    • Number[0..1]

pow​

pow(base: Number[1], exponent: Number[1]): Number[1]

  • Parameters

    • base: Number[1]
    • exponent: Number[1]

  • Returns

    • Number[1]

project​

Project the specified calculated columns from the provided TDS. This is similar to extend, but rather than adding the columns it replaces all of the existing ones
project(tds: TabularDataSet[1], columnFunctions: ColumnSpecification<TDSRow<[*]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • columnFunctions: ColumnSpecification<TDSRow<[*]

  • Returns

    • TabularDataSet[1]
Project the specified calculated columns from the provided TDS. This is similar to extend, but rather than adding the columns it replaces all of the existing ones
project(tds: TableTDS[1], columnFunctions: ColumnSpecification<TDSRow<[*]): TabularDataSet[1]

  • Parameters

    • tds: TableTDS[1]
    • columnFunctions: ColumnSpecification<TDSRow<[*]

  • Returns

    • TabularDataSet[1]
Project the values from the columns specifications provided to create a new TDS
project<T>(set: T[*], columnSpecifications: ColumnSpecification<T<[*]): TabularDataSet[1]

  • Parameters

    • set: T[*]
    • columnSpecifications: ColumnSpecification<T<[*]

  • Returns

    • TabularDataSet[1]
Project the values from the property paths specified to create a new TDS
project<T>(set: T[*], paths: Path<T,Any|*>[*]): TabularDataSet[1]

  • Parameters

    • set: T[*]
    • paths: Path<T,Any|*>[*]

  • Returns

    • TabularDataSet[1]
Project the values from the lambda functions specified to create a new TDS
project<K>(set: K[*], functions: Function<{"{"}K[1]->Any[*]{"}"}<[*], ids: String[*]): TabularDataSet[1]

  • Parameters

    • set: K[*]
    • functions: Function<{"{"}K[1]->Any[]{"}"}<[]
    • ids: String[*]

  • Returns

    • TabularDataSet[1]

projectWithColumnSubset​

projectWithColumnSubset<T>(set: T[*], columnSpecifications: ColumnSpecification<T<[*], columnList: String[*]): TabularDataSet[1]

  • Parameters

    • set: T[*]
    • columnSpecifications: ColumnSpecification<T<[*]
    • columnList: String[*]

  • Returns

    • TabularDataSet[1]
projectWithColumnSubset<T>(set: T[*], functions: Function<{"{"}T[1]->Any[*]{"}"}<[*], ids: String[*], columnList: String[*]): TabularDataSet[1]

  • Parameters

    • set: T[*]
    • functions: Function<{"{"}T[1]->Any[]{"}"}<[]
    • ids: String[*]
    • columnList: String[*]

  • Returns

    • TabularDataSet[1]

renameColumns​

Rename the specified columns in the provided TDS to a new name
renameColumns(tds: TabularDataSet[1], columnMappings: Pair<String,String<[*]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • columnMappings: Pair<String,String<[*]

  • Returns

    • TabularDataSet[1]

restrict​

Restrict / reduce the columns from within the provided TDS
restrict(tds: TabularDataSet[1], columnNames: String[*]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • columnNames: String[*]

  • Returns

    • TabularDataSet[1]

round​

round(float: Float[1], scale: Integer[1]): Float[1]

  • Parameters

    • float: Float[1]
    • scale: Integer[1]

  • Returns

    • Float[1]

slice​

Reduce the number of rows in the provided TDS, selecting the set of rows in the specified range between start and stop
slice(tds: TabularDataSet[1], start: Integer[1], stop: Integer[1]): TabularDataSet[1]

  • Parameters

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

  • Returns

    • TabularDataSet[1]

sort​

Sort the provided TDS based on the specified column & direction
sort(tds: TabularDataSet[1], column: String[1], direction: SortDirection[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • column: String[1]
    • direction: SortDirection[1]

  • Returns

    • TabularDataSet[1]
Sort the provided TDS based on the specified column (with ascending direction)
sort(tds: TabularDataSet[1], columns: String[*]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • columns: String[*]

  • Returns

    • TabularDataSet[1]
Sort the provided TDS based on the specified information (sorting is based on order of the sort information)
sort(tds: TabularDataSet[1], sortInfo: SortInformation[*]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • sortInfo: SortInformation[*]

  • Returns

    • TabularDataSet[1]

sqrt​

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

  • Parameters

    • number: Number[1]

  • Returns

    • Float[1]

stdDevPopulation​

stdDevPopulation(numbers: Number[*]): Number[1]

  • Parameters

    • numbers: Number[*]

  • Returns

    • Number[1]

stdDevSample​

stdDevSample(numbers: Number[*]): Number[1]

  • Parameters

    • numbers: Number[*]

  • Returns

    • Number[1]

subType​

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

  • Parameters

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

  • Returns

    • T[m]

tableToTDS​

tableToTDS(table: Table[1]): TableTDS[1]

  • Parameters

    • table: Table[1]

  • Returns

    • TableTDS[1]

take​

Reduce the number of rows in the provided TDS, taking the first set of rows based on the specified size
take(tds: TabularDataSet[1], size: Integer[1]): TabularDataSet[1]

  • Parameters

    • tds: TabularDataSet[1]
    • size: Integer[1]

  • Returns

    • TabularDataSet[1]
  • Usage

{|Person->getAll()->project(name)->take(0)}

tan​

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

  • Parameters

    • number: Number[1]

  • Returns

    • Float[1]

tdsContains​

tdsContains<T>(object: T[1], functions: Function<{"{"}T[1]->Any[0..1]{"}"}<[*], ids: String[*], tds: TabularDataSet[1], crossOperation: Function<{"{"}TDSRow[1],TDSRow[1]->Boolean[1]{"}"}<[1]): Boolean[1]

  • Parameters

    • object: T[1]
    • functions: Function<{"{"}T[1]->Any[0..1]{"}"}<[*]
    • ids: String[*]
    • tds: TabularDataSet[1]
    • crossOperation: Function<{"{"}TDSRow[1],TDSRow[1]->Boolean[1]{"}"}<[1]

  • Returns

    • Boolean[1]
tdsContains<T>(object: T[1], functions: Function<{"{"}T[1]->Any[0..1]{"}"}<[*], tds: TabularDataSet[1]): Boolean[1]

  • Parameters

    • object: T[1]
    • functions: Function<{"{"}T[1]->Any[0..1]{"}"}<[*]
    • tds: TabularDataSet[1]

  • Returns

    • Boolean[1]

tdsRows​

tdsRows(tds: TabularDataSet[1]): TDSRow[*]

  • Parameters

    • tds: TabularDataSet[1]

  • Returns

    • TDSRow[*]

viewToTDS​

viewToTDS(view: View[1]): TableTDS[1]

  • Parameters

    • view: View[1]

  • Returns

    • TableTDS[1]

More​