Interface CellScalarContext

interface CellScalarContext {
    $column: any;
    $columns: IColumnSet;
    $data: IDataContext;
    $date: IDateFunctions;
    $excel: __module;
    $lookup: {
        findAccount: (
            this: ExprAppContext,
            name: string,
            byOrOpts?: string | string[] | IFindAccountOpts,
        ) => Promise<string>;
        findClient: (
            this: ExprAppContext,
            value: string,
            options?: IFindClientOpts,
        ) => Promise<ISimpleClient>;
        findClientObject: (
            this: ExprAppContext,
            value: string,
            options?: IFindClientOpts,
        ) => Promise<ISimpleClient>;
        findEntity: (
            this: ExprAppContext,
            name: string,
            opts?: IFindEntityOpts,
        ) => Promise<string>;
        findSecurity: (
            this: ExprAppContext,
            name: string,
            opts?: IFindSecurityOpts,
        ) => Promise<string>;
        queryDocuments: (
            this: ExprAppContext,
            query: string,
            opts?: QueryDocumentOpts,
        ) => Promise<ApiDocument[]>;
        queryEvents: (
            this: ExprAppContext,
            value: string,
            opts?: QueryEventOpts,
        ) => Promise<Partial<Events>[]>;
        queryObservables: (
            this: ExprAppContext,
            type: string,
            opts?: QueryObservableOpts,
        ) => Promise<Observable_Data[]>;
    };
    $number: INumberFunctions;
    $placeholders: {
        client_identifier: { adviser: string };
        global_advisor: string;
        global_bank: string;
        global_dealer: string;
        global_exchange: string;
        global_insurer: string;
        global_participant: string;
        primary_entity: string;
    };
    $scalar: Record<string, any>;
    BigInt: BigIntConstructor;
    Date: DateConstructor;
    Math: Math;
    Number: NumberConstructor;
    Series: typeof Series;
    String: StringConstructor;
    $cond(clause1: CondClause, ...clauseN: CondClause): any;
    $const(name: string, value: string): void;
    $if(expr: any, trueValue?: any, falseValue?: any): any;
    $try(expr1: any, expr2?: any, ...exprN: any): any;
    NumberParser(lang?: string): NumberParser;
    [key: string]: any;
}

Hierarchy (View Summary)

Indexable

  • [key: string]: any

Properties

$column $columns $data $date $excel $lookup $number $placeholders $scalar BigInt Date Math Number Series String

Methods

$cond $const $if $try NumberParser

Properties

$column

$column: any

A column object

$columns

$columns: IColumnSet

Get the

$data

$data: IDataContext

$date

$date: IDateFunctions

Date Utility functions

$excel

$excel: __module

$lookup

$lookup: {
    findAccount: (
        this: ExprAppContext,
        name: string,
        byOrOpts?: string | string[] | IFindAccountOpts,
    ) => Promise<string>;
    findClient: (
        this: ExprAppContext,
        value: string,
        options?: IFindClientOpts,
    ) => Promise<ISimpleClient>;
    findClientObject: (
        this: ExprAppContext,
        value: string,
        options?: IFindClientOpts,
    ) => Promise<ISimpleClient>;
    findEntity: (
        this: ExprAppContext,
        name: string,
        opts?: IFindEntityOpts,
    ) => Promise<string>;
    findSecurity: (
        this: ExprAppContext,
        name: string,
        opts?: IFindSecurityOpts,
    ) => Promise<string>;
    queryDocuments: (
        this: ExprAppContext,
        query: string,
        opts?: QueryDocumentOpts,
    ) => Promise<ApiDocument[]>;
    queryEvents: (
        this: ExprAppContext,
        value: string,
        opts?: QueryEventOpts,
    ) => Promise<Partial<Events>[]>;
    queryObservables: (
        this: ExprAppContext,
        type: string,
        opts?: QueryObservableOpts,
    ) => Promise<Observable_Data[]>;
}

Lookup Utility Functions

Type declaration

$number

$number: INumberFunctions

Number utility functions

$placeholders

$placeholders: {
    client_identifier: { adviser: string };
    global_advisor: string;
    global_bank: string;
    global_dealer: string;
    global_exchange: string;
    global_insurer: string;
    global_participant: string;
    primary_entity: string;
}

Type declaration

  • client_identifier: { adviser: string }

    Placeholder Values for Client Identifier

    • adviser: string

      Placeholder that will resolve to the universe of the adviser,running the import process

  • global_advisor: string
  • global_bank: string
  • global_dealer: string

    Placeholder that is resolved to the UUID of the global dealer entity

  • global_exchange: string

    Placeholder that will be resolved to the UUID of the global exchange entity

  • global_insurer: string
  • global_participant: string

    Placeholder that will be resolved to the UUID of the global participant entity

  • primary_entity: string

    Placeholder that is resolved to the UUID for the primary entity of the universe performing this import

$scalar

$scalar: Record<string, any>

Object containing all defined scalar values

BigInt

BigInt: BigIntConstructor

Standard javascript Date object global.BigInt

Date

Date: DateConstructor

Standard javascript Date object global.Date

Math

Math: Math

Standard javascript Math object global.Math

Number

Number: NumberConstructor

Standard javascript Number object global.Number

Series

Series: typeof Series

String

String: StringConstructor

Standard javscript String object global.String

Methods

$cond

  • $cond(clause1: CondClause, ...clauseN: CondClause): any

    Evaluate and return the condValueExpr for the first matching condExpr. This function works like a switch statement. Each argument is tested in order and and the first clause with a condExpr component that is truthy will result in the condValueExpr being returned. If no expression are valid the result is undefined. All parameters are evaluated lazily

    Parameters

    Returns any

$const

$if

  • $if(expr: any, trueValue?: any, falseValue?: any): any

    Evaluate expr and return trueValue if it is true and falseValue otherwise Parameters are evaluated lazily so only one of trueValue|falseValue will be evaluated

    Parameters

    • expr: any

      conditional Expression to evaluate

    • OptionaltrueValue: any

      expression to evaluate if expr is truthy

    • OptionalfalseValue: any

      expression to evaluate if expr is falsy

    Returns any

$try

  • $try(expr1: any, expr2?: any, ...exprN: any): any

    Evaluate expression in sequence and return the first expression that does not throw an exception.

    Parameters are evaluated lazily

    Parameters

    • expr1: any

      first Expression

    • Optionalexpr2: any

      second expression

    • ...exprN: any

      Nth expression

    Returns any

    undefined if all expressions throw exceptions

NumberParser

Settings

Member Visibility

On This Page

Properties
Methods