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

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

  • Parameters

    • value: any

    Returns DateTime | null

Static avgNulls

  • avgNulls(value: any): number

  • Parameters

    • value: any

    Returns number

Static avgTime

  • 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

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

    Returns number

Static dayObject

  • dayObject(value: any): any

  • Parameters

    • value: any

    Returns any

Static dayOfWeek

  • dayOfWeek(date: DateTime | null): string

  • Parameters

    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

    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

Static dayOfWeekIdentObject

  • dayOfWeekIdentObject(value: any): any

  • Parameters

    • value: any

    Returns any

Static dayOfWeekIndex

  • dayOfWeekIndex(dateTime: DateTime | null): number

  • Parameters

    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

    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

    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

    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

Static financialQuarterIndex

  • financialQuarterIndex(dateTime: DateTime | null): number

  • Parameters

    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

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

Static getCustomFunctions

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

Static hour

  • hour(dateTime: DateTime | null): number

  • Parameters

    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

    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

  • 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

  • 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

  • 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

  • Parameters

    • value: any

    Returns TimeSpan | null

Static minute

  • minute(dateTime: DateTime | null): number

  • Parameters

    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

    Returns number

Static monthIdent

Static monthIdentObject

  • monthIdentObject(value: any): any

  • Parameters

    • value: any

    Returns any

Static monthName

  • monthName(date: DateTime | null): string

  • Parameters

    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

    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

Static optionalSkipNulls

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

  • Parameters

    • values: List<object>

    Returns List<object>

Static quarter

Static quarterIndex

  • quarterIndex(dateTime: DateTime | null): number

  • Parameters

    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

    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

    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 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

  • 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 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

    Returns number

Static yearMonth

  • yearMonth(dateTime: DateTime | null): string

  • Parameters

    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