Class Funcs

Hierarchy

Funcs

Index

Methods

Methods

Static abs

abs(value: number): number

Parameters
- value: number
Returns number

Static absObject

absObject(value: any): any

Parameters
- value: any
Returns any

Static acos

acos(value: number): number

Parameters
- value: number
Returns number

Static acosObject

acosObject(value: any): any

Parameters
- value: any
Returns any

Static addMonthsObject

addMonthsObject(date: any, months: number): any

Parameters
- date: any
- months: number
Returns any

Static addYears

addYears(date: DateTime, years: number): DateTime

Parameters
- date: DateTime
- years: number
Returns DateTime

Static addYearsObject

addYearsObject(date: any, years: number): any

Parameters
- date: any
- years: number
Returns any

Static all

all(value: any): any

Parameters
- value: any
Returns any

Static asin

asin(value: number): number

Parameters
- value: number
Returns number

Static asinObject

asinObject(value: any): any

Parameters
- value: any
Returns any

Static atan

atan(value: number): any

Parameters
- value: number
Returns any

Static atanObject

atanObject(value: any): any

Parameters
- value: any
Returns any

Static avg

avg(value: any): number

Parameters
- value: any
Returns number

Static avgDate

avgDate(value: any): DateTime | null

Parameters
- value: any
Returns DateTime | null

Static avgNulls

avgNulls(value: any): number

Parameters
- value: any
Returns number

Static avgTime

avgTime(value: any): TimeSpan | null

Parameters
- value: any
Returns TimeSpan | null

Static calculate

calculate(functionn: string, values: List<object>): any

Parameters
- functionn: string
- values: List<object>
Returns any

Static ceiling

ceiling(value: number): number

Parameters
- value: number
Returns number

Static ceilingObject

ceilingObject(value: any): any

Parameters
- value: any
Returns any

Static cos

cos(value: number): number

Parameters
- value: number
Returns number

Static cosObject

cosObject(value: any): any

Parameters
- value: any
Returns any

Static count

count(value: any): number

Parameters
- value: any
Returns number

Static countIf

countIf(value: any, condition: any): number

Parameters
- value: any
- condition: any
Returns number

Static dateDiff

dateDiff(date1: DateTime | null, date2: DateTime | null): TimeSpan | null

Parameters
- date1: DateTime | null
- date2: DateTime | null
Returns TimeSpan | null

Static dateDiffObject

dateDiffObject(value1: any, value2: any): any

Parameters
- value1: any
- value2: any
Returns any

Static dateTime

dateTime(value: any): any

Parameters
- value: any
Returns any

Static day

day(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static dayObject

dayObject(value: any): any

Parameters
- value: any
Returns any

Static dayOfWeek

dayOfWeek(date: DateTime | null): string

Parameters
- date: DateTime | null
Returns string

Static dayOfWeek2

dayOfWeek2(date: DateTime | null, localized: boolean): string

Parameters
- date: DateTime | null
- localized: boolean
Returns string

Static dayOfWeek3

dayOfWeek3(date: DateTime | null, culture: string): string

Parameters
- date: DateTime | null
- culture: string
Returns string

Static dayOfWeek4

dayOfWeek4(date: DateTime | null, culture: string, upperCase: boolean): string

Parameters
- date: DateTime | null
- culture: string
- upperCase: boolean
Returns string

Static dayOfWeekIdent

dayOfWeekIdent(dateTime: DateTime | null): DayOfWeek | null

Parameters
- dateTime: DateTime | null
Returns DayOfWeek | null

Static dayOfWeekIdentObject

dayOfWeekIdentObject(value: any): any

Parameters
- value: any
Returns any

Static dayOfWeekIndex

dayOfWeekIndex(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static dayOfWeekIndexObject

dayOfWeekIndexObject(value: any): any

Parameters
- value: any
Returns any

Static dayOfWeekObject

dayOfWeekObject(value: any): any

Parameters
- value: any
Returns any

Static dayOfWeekObject2

dayOfWeekObject2(value: any, localized: boolean): any

Parameters
- value: any
- localized: boolean
Returns any

Static dayOfWeekObject3

dayOfWeekObject3(value: any, culture: string): any

Parameters
- value: any
- culture: string
Returns any

Static dayOfWeekObject4

dayOfWeekObject4(value: any, culture: string, upperCase: boolean): any

Parameters
- value: any
- culture: string
- upperCase: boolean
Returns any

Static dayOfYear

dayOfYear(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static dayOfYearObject

dayOfYearObject(value: any): any

Parameters
- value: any
Returns any

Static daysInMonth

daysInMonth(year: number, month: number): number

Parameters
- year: number
- month: number
Returns number

Static daysInMonth2

daysInMonth2(date: DateTime | null): number

Parameters
- date: DateTime | null
Returns number

Static daysInMonthObject

daysInMonthObject(value1: any, value2: any): any

Parameters
- value1: any
- value2: any
Returns any

Static daysInMonthObject2

daysInMonthObject2(value: any): any

Parameters
- value: any
Returns any

Static daysInYear

daysInYear(year: number): number

Parameters
- year: number
Returns number

Static daysInYear2

daysInYear2(date: DateTime | null): number

Parameters
- date: DateTime | null
Returns number

Static daysInYearObject

daysInYearObject(value: any): any

Parameters
- value: any
Returns any

Static distinct

distinct(value: any): any

Parameters
- value: any
Returns any

Static distinctCount

distinctCount(value: any): number

Parameters
- value: any
Returns number

Static distinctCountIf

distinctCountIf(value: any, condition: any): number

Parameters
- value: any
- condition: any
Returns number

Static div

div(value1: number, value2: number, zeroResult?: number | null): number | null

Parameters
- value1: number
- value2: number
- Default value zeroResult: number | null = null
Returns number | null

Static divObject

divObject(value1: any, value2: any, zeroResult?: any): number

Parameters
- value1: any
- value2: any
- Default value zeroResult: any = null
Returns number

Static existsCustomFunction

existsCustomFunction(funcName: string): boolean

Parameters
- funcName: string
Returns boolean

Static exp

exp(value: number): number

Parameters
- value: number
Returns number

Static expObject

expObject(value: any): any

Parameters
- value: any
Returns any

Static financialQuarter

financialQuarter(dateTime: DateTime | null): StiQuarter | null

Parameters
- dateTime: DateTime | null
Returns StiQuarter | null

Static financialQuarterIndex

financialQuarterIndex(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static financialQuarterIndexObject

financialQuarterIndexObject(value: any): any

Parameters
- value: any
Returns any

Static financialQuarterObject

financialQuarterObject(value: any): any

Parameters
- value: any
Returns any

Static first

first(value: any): any

Parameters
- value: any
Returns any

Static fiscalMonthIdent

fiscalMonthIdent(dateTime: DateTime, startMonth: any): StiFiscalMonth

Parameters
- dateTime: DateTime
- startMonth: any
Returns StiFiscalMonth

Static fiscalMonthIdentObject

fiscalMonthIdentObject(value: any, startMonth: any): any

Parameters
- value: any
- startMonth: any
Returns any

Static floor

floor(value: number): number

Parameters
- value: number
Returns number

Static floorObject

floorObject(value: any): any

Parameters
- value: any
Returns any

Static format

format(format: string, value: any): string

Parameters
- format: string
- value: any
Returns string

Static formatObject

formatObject(format: string, value: any): any

Parameters
- format: string
- value: any
Returns any

Static getAggregateMeasureFunctions

getAggregateMeasureFunctions(): List<string>

Returns List<string>

Static getCommonMeasureFunctions

getCommonMeasureFunctions(): List<string>

Returns List<string>

Static getCustomFunction

getCustomFunction(funcName: string, argumentTypes: List<Type>): IStiAppFunction

Parameters
- funcName: string
- argumentTypes: List<Type>
Returns IStiAppFunction

Static getCustomFunctions

getCustomFunctions(funcName: string): List<IStiAppFunction>

Parameters
- funcName: string
Returns List<IStiAppFunction>

Static getDateDimensionFunctions

getDateDimensionFunctions(): List<string>

Returns List<string>

Static getIso2ConvertedValues

getIso2ConvertedValues(name: string): List<string>

Parameters
- name: string
Returns List<string>

Static getMapIdents

getMapIdents(key: string): List<string>

Parameters
- key: string
Returns List<string>

Static getMeasureFunctions

getMeasureFunctions(): List<string>

Returns List<string>

Static getSystemVariable

getSystemVariable(variable: StiSystemVariableObject, line: number): any

Parameters
- variable: StiSystemVariableObject
- line: number
Returns any

Static hour

hour(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static hourObject

hourObject(value: any): any

Parameters
- value: any
Returns any

Static image

image(value: any, width?: number, height?: number): any

Parameters
- value: any
- Default value width: number = 200
- Default value height: number = 200
Returns any

Static insert

insert(str: string, startIndex: number, subStr: string): string

Parameters
- str: string
- startIndex: number
- subStr: string
Returns string

Static insertObject

insertObject(value: any, startIndex: number, subStr: string): any

Parameters
- value: any
- startIndex: number
- subStr: string
Returns any

Static invokeCustomFunction

invokeCustomFunction(funcName: string, argumentss: List<any>): any

Parameters
- funcName: string
- argumentss: List<any>
Returns any

Static isAggregationFunction

isAggregationFunction(functionn: string): boolean

Parameters
- functionn: string
Returns boolean

Static isDataEqual

isDataEqual(dataSource: IStiAppDataSource, dataColumnName: string, searchColumnName: string): boolean

Parameters
- dataSource: IStiAppDataSource
- dataColumnName: string
- searchColumnName: string
Returns boolean

Static isMeasureFunction

isMeasureFunction(expression: string): boolean

Parameters
- expression: string
Returns boolean

Static isValidUrl

isValidUrl(hyperlink: string): boolean

Parameters
- hyperlink: string
Returns boolean

Static iso2

iso2(name: string, mapId: string, lang: string): string

Parameters
- name: string
- mapId: string
- lang: string
Returns string

Static iso2Object

iso2Object(value: any, mapId: string, lang: string): any

Parameters
- value: any
- mapId: string
- lang: string
Returns any

Static iso2ToName

iso2ToName(alpha2: string, mapId: string, lang: string): string

Parameters
- alpha2: string
- mapId: string
- lang: string
Returns string

Static iso2ToNameObject

iso2ToNameObject(value: any, mapId: string, lang: string): any

Parameters
- value: any
- mapId: string
- lang: string
Returns any

Static iso3

iso3(name: string, mapId: string, lang: string): string

Parameters
- name: string
- mapId: string
- lang: string
Returns string

Static iso3Object

iso3Object(value: any, mapId: string, lang: string): any

Parameters
- value: any
- mapId: string
- lang: string
Returns any

Static iso3ToName

iso3ToName(alpha3: string, mapId: string, lang: string): string

Parameters
- alpha3: string
- mapId: string
- lang: string
Returns string

Static iso3ToNameObject

iso3ToNameObject(value: any, mapId: string, lang: string): any

Parameters
- value: any
- mapId: string
- lang: string
Returns any

Static last

last(value: any): any

Parameters
- value: any
Returns any

Static left

left(str: string, length?: number): string

Parameters
- str: string
- Default value length: number = -1
Returns string

Static leftObject

leftObject(value: any, length?: number): any

Parameters
- value: any
- Default value length: number = -1
Returns any

Static length2

length2(str: string): number

Parameters
- str: string
Returns number

Static lengthObject

lengthObject(value: any): any

Parameters
- value: any
Returns any

Static localize

localize(func: string): string

Parameters
- func: string
Returns string

Static log

log(value: number): number

Parameters
- value: number
Returns number

Static logObject

logObject(value: any): any

Parameters
- value: any
Returns any

Static makeDate

makeDate(year: number, month?: number, day?: number): DateTime

Parameters
- year: number
- Default value month: number = 1
- Default value day: number = 1
Returns DateTime

Static makeDateObject

makeDateObject(year: any, month?: any, day?: any): any

Parameters
- year: any
- Default value month: any = null
- Default value day: any = null
Returns any

Static makeDateTime

makeDateTime(year: number, month?: number, day?: number, hour?: number, minute?: number, second?: number): DateTime

Parameters
- year: number
- Default value month: number = 1
- Default value day: number = 1
- Default value hour: number = 0
- Default value minute: number = 0
- Default value second: number = 0
Returns DateTime

Static makeDateTimeObject

makeDateTimeObject(year: any, month?: any, day?: any, hour?: any, minute?: any, second?: any): any

Parameters
- year: any
- Default value month: any = null
- Default value day: any = null
- Default value hour: any = null
- Default value minute: any = null
- Default value second: any = null
Returns any

Static makeTime

makeTime(hour: number, minute?: number, second?: number): DateTime

Parameters
- hour: number
- Default value minute: number = 0
- Default value second: number = 0
Returns DateTime

Static makeTimeObject

makeTimeObject(hour: any, minute?: any, second?: any): any

Parameters
- hour: any
- Default value minute: any = null
- Default value second: any = null
Returns any

Static max

max(value: any): number

Parameters
- value: any
Returns number

Static maxD

maxD(value: any): number

Parameters
- value: any
Returns number

Static maxDate

maxDate(value: any): DateTime | null

Parameters
- value: any
Returns DateTime | null

Static maxI

maxI(value: any): number

Parameters
- value: any
Returns number

Static maxNulls

maxNulls(value: number): number

Parameters
- value: number
Returns number

Static maxStr

maxStr(value: any): string

Parameters
- value: any
Returns string

Static maxTime

maxTime(value: any): TimeSpan | null

Parameters
- value: any
Returns TimeSpan | null

Static median

median(value: any): number

Parameters
- value: any
Returns number

Static min

min(value: any): number

Parameters
- value: any
Returns number

Static minDate

minDate(value: any): DateTime | null

Parameters
- value: any
Returns DateTime | null

Static minMaxDateString

minMaxDateString(value: any): string

Parameters
- value: any
Returns string

Static minNulls

minNulls(value: any): number

Parameters
- value: any
Returns number

Static minStr

minStr(value: any): string

Parameters
- value: any
Returns string

Static minTime

minTime(value: any): TimeSpan | null

Parameters
- value: any
Returns TimeSpan | null

Static minute

minute(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static minuteObject

minuteObject(value: any): any

Parameters
- value: any
Returns any

Static mode

mode(value: any): number

Parameters
- value: any
Returns number

Static month

month(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static monthIdent

monthIdent(dateTime: DateTime | null): StiMonth | null

Parameters
- dateTime: DateTime | null
Returns StiMonth | null

Static monthIdentObject

monthIdentObject(value: any): any

Parameters
- value: any
Returns any

Static monthName

monthName(date: DateTime | null): string

Parameters
- date: DateTime | null
Returns string

Static monthName2

monthName2(date: DateTime | null, localized: boolean): string

Parameters
- date: DateTime | null
- localized: boolean
Returns string

Static monthName3

monthName3(date: DateTime | null, culture: string): string

Parameters
- date: DateTime | null
- culture: string
Returns string

Static monthName4

monthName4(date: DateTime | null, culture: string, upperCase: boolean): string

Parameters
- date: DateTime | null
- culture: string
- upperCase: boolean
Returns string

Static monthNameObject

monthNameObject(value: any): any

Parameters
- value: any
Returns any

Static monthNameObject2

monthNameObject2(value: any, localized: boolean): any

Parameters
- value: any
- localized: boolean
Returns any

Static monthNameObject3

monthNameObject3(value: any, culture: string): any

Parameters
- value: any
- culture: string
Returns any

Static monthNameObject4

monthNameObject4(value: any, culture: string, upperCase: boolean): any

Parameters
- value: any
- culture: string
- upperCase: boolean
Returns any

Static monthObject

monthObject(value: any): any

Parameters
- value: any
Returns any

Static normalizeName

normalizeName(alpha3: string, mapId: string, lang: string): string

Parameters
- alpha3: string
- mapId: string
- lang: string
Returns string

Static normalizeNameObject

normalizeNameObject(value: any, mapId: string, lang: string): any

Parameters
- value: any
- mapId: string
- lang: string
Returns any

Static now

now(): DateTime

Returns DateTime

Static optionalSkipNulls

optionalSkipNulls(values: List<object>): List<object>

Parameters
- values: List<object>
Returns List<object>

Static quarter

quarter(dateTime: DateTime | null): StiQuarter | null

Parameters
- dateTime: DateTime | null
Returns StiQuarter | null

Static quarterIndex

quarterIndex(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static quarterIndexObject

quarterIndexObject(value: any): any

Parameters
- value: any
Returns any

Static quarterName

quarterName(dateTime: DateTime | null, localized?: boolean): string

Parameters
- dateTime: DateTime | null
- Default value localized: boolean = true
Returns string

Static quarterNameObject

quarterNameObject(value: any, localized?: boolean): any

Parameters
- value: any
- Default value localized: boolean = true
Returns any

Static quarterObject

quarterObject(value: any): any

Parameters
- value: any
Returns any

Static remove

remove(str: string, startIndex: number, count: number): string

Parameters
- str: string
- startIndex: number
- count: number
Returns string

Static removeObject

removeObject(value: any, startIndex: number, count: number): any

Parameters
- value: any
- startIndex: number
- count: number
Returns any

Static replace

replace(str: string, oldValue: string, newValue: string): string

Parameters
- str: string
- oldValue: string
- newValue: string
Returns string

Static replaceObject

replaceObject(value: any, oldValue: string, newValue: string): any

Parameters
- value: any
- oldValue: string
- newValue: string
Returns any

Static right

right(str: string, length?: number): string

Parameters
- str: string
- Default value length: number = -1
Returns string

Static rightObject

rightObject(value: any, length?: number): any

Parameters
- value: any
- Default value length: number = -1
Returns any

Static round

round(value: number, decimals?: number): number

Parameters
- value: number
- Default value decimals: number = 0
Returns number

Static roundObject

roundObject(value: any, decimals?: number): any

Parameters
- value: any
- Default value decimals: number = 0
Returns any

Static second

second(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static secondObject

secondObject(value: any): any

Parameters
- value: any
Returns any

Static sign

sign(value: number): number

Parameters
- value: number
Returns number

Static signObject

signObject(value: any): any

Parameters
- value: any
Returns any

Static sin

sin(value: number): number

Parameters
- value: number
Returns number

Static sinObject

sinObject(value: any): any

Parameters
- value: any
Returns any

Static skipNulls

skipNulls(values: List<any>): List<any>

Parameters
- values: List<any>
Returns List<any>

Static sqrt

sqrt(value: number): number

Parameters
- value: number
Returns number

Static sqrtObject

sqrtObject(value: any): any

Parameters
- value: any
Returns any

Static stDev

stDev(value: any): number

Parameters
- value: any
Returns number

Static stDevP

stDevP(value: any): number

Parameters
- value: any
Returns number

Static substring

substring(str: string, startIndex: number, length?: number): string

Parameters
- str: string
- startIndex: number
- Default value length: number = -1
Returns string

Static substringObject

substringObject(value: any, startIndex: number, length?: number): any

Parameters
- value: any
- startIndex: number
- Default value length: number = -1
Returns any

Static sum

sum(value: any): number

Parameters
- value: any
Returns number

Static sumD

sumD(value: any): number

Parameters
- value: any
Returns number

Static sumDIf

sumDIf(value: any, condition: any): number

Parameters
- value: any
- condition: any
Returns number

Static sumDistinct

sumDistinct(value: any): number

Parameters
- value: any
Returns number

Static sumDistinctIf

sumDistinctIf(value: any, condition: any): number

Parameters
- value: any
- condition: any
Returns number

Static sumI

sumI(value: any): number

Parameters
- value: any
Returns number

Static sumIIf

sumIIf(value: any, condition: any): number

Parameters
- value: any
- condition: any
Returns number

Static sumIf

sumIf(value: any, condition: any): number

Parameters
- value: any
- condition: any
Returns number

Static sumNulls

sumNulls(value: any): number

Parameters
- value: any
Returns number

Static sumTime

sumTime(value: any): TimeSpan

Parameters
- value: any
Returns TimeSpan

Static sumTimeIf

sumTimeIf(value: any, condition: any): TimeSpan

Parameters
- value: any
- condition: any
Returns TimeSpan

Static tan

tan(value: number): number

Parameters
- value: number
Returns number

Static tanObject

tanObject(value: any): any

Parameters
- value: any
Returns any

Static time

time(value: any): any

Parameters
- value: any
Returns any

Static toABC

toABC(value: number): string

Converts the number to A B C D representation for numbering of the list.

Parameters
- value: number
  
  A number for converting into the A B C representation.
Returns string

String representation of the value in A B C D format.

Static toABCNumeric

toABCNumeric(value: number): string

Converts the number to A B C D representation for numbering of the list.

Parameters
- value: number
  
  A number for converting into the A B C representation.
Returns string

String representation of the value in A B C D format.

Static toABCRu

toABCRu(value: number): string

Converts the number to ¿ ¡ ¬ representation for numbering of the list in russian.

Parameters
- value: number
  
  A number for converting into the ¿ ¡ ¬ representation.
Returns string

String representation of the value in ¿ ¡ ¬ format.

Static toArabic

toArabic(value: string | number, useEasternDigits: boolean): string

Converts all digits in the string to the arabic representation.

Parameters
- value: string | number
  
  A string or number for converting into the arabic representation.
- useEasternDigits: boolean
  
  Use eastern or standard arabic digits.
Returns string

String with arabic digits.

Static toDataName

toDataName(name: string): string

Parameters
- name: string
Returns string

Static toDataNameWithoutRelation

toDataNameWithoutRelation(name: string, dataSources: List<IStiAppDataSource>): string

Parameters
- name: string
- dataSources: List<IStiAppDataSource>
Returns string

Static toExpression

toExpression(name: string): string

Parameters
- name: string
Returns string

Static toExpression2

toExpression2(sourceName: string, columnName: string): string

Parameters
- sourceName: string
- columnName: string
Returns string

Static toLowerCase

toLowerCase(str: string): string

Parameters
- str: string
Returns string

Static toLowerCaseObject

toLowerCaseObject(value: any): any

Parameters
- value: any
Returns any

Static toProperCase

toProperCase(str: string): string

Parameters
- str: string
Returns string

Static toProperCaseObject

toProperCaseObject(value: any): any

Parameters
- value: any
Returns any

Static toRoman

toRoman(value: number): string

Converts Arabic numerals to Roman.

Parameters
- value: number
  
  Arabic numerals for converting to the Roman format.
Returns string

Returns Arabics numerals in Roman.

Static toString

toString(value: any): string

Parameters
- value: any
Returns string

Static toStringObject

toStringObject(value: any): any

Parameters
- value: any
Returns any

Static toUpperCase

toUpperCase(str: string): string

Parameters
- str: string
Returns string

Static toUpperCaseObject

toUpperCaseObject(value: any): any

Parameters
- value: any
Returns any

Static trim

trim(str: string): string

Parameters
- str: string
Returns string

Static trimEnd

trimEnd(str: string): string

Parameters
- str: string
Returns string

Static trimEndObject

trimEndObject(value: any): any

Parameters
- value: any
Returns any

Static trimObject

trimObject(value: any): any

Parameters
- value: any
Returns any

Static trimStart

trimStart(str: string): string

Parameters
- str: string
Returns string

Static trimStartObject

trimStartObject(value: any): any

Parameters
- value: any
Returns any

Static truncate

truncate(value: number): number

Parameters
- value: number
Returns number

Static truncateObject

truncateObject(value: any): any

Parameters
- value: any
Returns any

Static year

year(dateTime: DateTime | null): number

Parameters
- dateTime: DateTime | null
Returns number

Static yearMonth

yearMonth(dateTime: DateTime | null): string

Parameters
- dateTime: DateTime | null
Returns string

Static yearMonthObject

yearMonthObject(value: any): any

Parameters
- value: any
Returns any

Static yearObject

yearObject(value: any): any

Parameters
- value: any
Returns any

Generated using TypeDoc