TableQuery

Defined in: src/entities/data-connection.ts:50

Represents a table query

Extends

• DataQuery

Constructors

Constructor

new TableQuery(dart): TableQuery

Defined in: src/entities/data-connection.ts:52

Parameters

Parameter	Type
dart	any

Returns

TableQuery

Constructs

TableQuery

Overrides

DataQuery.constructor

Properties

Property	Modifier	Type	Inherited from	Defined in
aux	public	any	DataQuery.aux	src/entities/func.ts:26
dart	public	any	DataQuery.dart	src/entities/entity.ts:19
options	public	object	DataQuery.options	src/entities/func.ts:27

Accessors

adHoc

Get Signature

get adHoc(): boolean

Defined in: src/entities/data-connection.ts:30

Deprecated

Use FuncCall.adHoc instead *

Returns

boolean

Set Signature

set adHoc(a): void

Defined in: src/entities/data-connection.ts:32

Deprecated

Use FuncCall.adHoc instead *

Parameters

Parameter	Type
a	boolean

Returns

void

Inherited from

DataQuery.adHoc

---

aggregations

Get Signature

get aggregations(): GroupAggregation[]

Defined in: src/entities/data-connection.ts:79

Aggregation clauses {queryPartParams}

Returns

GroupAggregation[]

Set Signature

set aggregations(wl): void

Defined in: src/entities/data-connection.ts:80

Parameters

Parameter	Type
wl	GroupAggregation[]

Returns

void

---

author

Get Signature

get author(): any

Defined in: src/entities/entity.ts:59

Who created entity *

Returns

any

Inherited from

DataQuery.author

---

connection

Get Signature

get connection(): DataConnection

Defined in: src/entities/data-connection.ts:38

Returns

DataConnection

Set Signature

set connection(c): void

Defined in: src/entities/data-connection.ts:39

Parameters

Parameter	Type
c	DataConnection

Returns

void

Inherited from

DataQuery.connection

---

createdOn

Get Signature

get createdOn(): Dayjs

Defined in: src/entities/entity.ts:50

Time when entity was created *

Returns

Dayjs

Inherited from

DataQuery.createdOn

---

description

Get Signature

get description(): string

Defined in: src/entities/func.ts:36

Returns

string

Inherited from

DataQuery.description

---

entityType

Get Signature

get entityType(): string

Defined in: src/entities/entity.ts:66

Entity type name *

Returns

string

Inherited from

DataQuery.entityType

---

fields

Get Signature

get fields(): string[]

Defined in: src/entities/data-connection.ts:68

Fields array

Returns

string[]

Set Signature

set fields(fields): void

Defined in: src/entities/data-connection.ts:69

Parameters

Parameter	Type
fields	string[]

Returns

void

---

friendlyName

Get Signature

get friendlyName(): string

Defined in: src/entities/entity.ts:36

Entity friendly name

Returns

string

Set Signature

set friendlyName(x): void

Defined in: src/entities/entity.ts:37

Parameters

Parameter	Type
x	string

Returns

void

Inherited from

DataQuery.friendlyName

---

having

Get Signature

get having(): FieldPredicate[]

Defined in: src/entities/data-connection.ts:86

Having clauses

Returns

FieldPredicate[]

Set Signature

set having(wl): void

Defined in: src/entities/data-connection.ts:87

Parameters

Parameter	Type
wl	FieldPredicate[]

Returns

void

---

helpUrl

Get Signature

get helpUrl(): string

Defined in: src/entities/func.ts:43

Help URL.

Returns

string

Set Signature

set helpUrl(url): void

Defined in: src/entities/func.ts:45

Parameters

Parameter	Type
url	string

Returns

void

Inherited from

DataQuery.helpUrl

---

id

Get Signature

get id(): string

Defined in: src/entities/entity.ts:28

Entity ID (GUID)

Returns

string

Set Signature

set id(x): void

Defined in: src/entities/entity.ts:29

Parameters

Parameter	Type
x	string

Returns

void

Inherited from

DataQuery.id

---

inputs

Get Signature

get inputs(): Property[]

Defined in: src/entities/func.ts:66

Input parameters

Returns

Property[]

Inherited from

DataQuery.inputs

---

isVectorFunc

Get Signature

get isVectorFunc(): boolean

Defined in: src/entities/func.ts:53

Indicates that the function (or script) is already vector, meaning it accepts vector input (an entire column) and processes it in a single call, rather than being executed separately for each scalar element (row)

Returns

boolean

Inherited from

DataQuery.isVectorFunc

---

joins

Get Signature

get joins(): TableJoin[]

Defined in: src/entities/data-connection.ts:82

Returns

TableJoin[]

Set Signature

set joins(j): void

Defined in: src/entities/data-connection.ts:83

Parameters

Parameter	Type
j	TableJoin[]

Returns

void

---

limit

Get Signature

get limit(): number | undefined

Defined in: src/entities/data-connection.ts:94

Returns

number | undefined

Set Signature

set limit(rows): void

Defined in: src/entities/data-connection.ts:93

Parameters

Parameter	Type
rows	number | undefined

Returns

void

---

name

Get Signature

get name(): string

Defined in: src/entities/entity.ts:40

Entity short name

Returns

string

Set Signature

set name(x): void

Defined in: src/entities/entity.ts:41

Parameters

Parameter	Type
x	string

Returns

void

Inherited from

DataQuery.name

---

nqName

Get Signature

get nqName(): string

Defined in: src/entities/entity.ts:44

Entity full-qualified name

Returns

string

Inherited from

DataQuery.nqName

---

orderBy

Get Signature

get orderBy(): FieldOrder[]

Defined in: src/entities/data-connection.ts:90

Order By clauses

Returns

FieldOrder[]

Set Signature

set orderBy(wl): void

Defined in: src/entities/data-connection.ts:91

Parameters

Parameter	Type
wl	FieldOrder[]

Returns

void

---

outputs

Get Signature

get outputs(): Property[]

Defined in: src/entities/func.ts:71

Output parameters

Returns

Property[]

Inherited from

DataQuery.outputs

---

package

Get Signature

get package(): any

Defined in: src/entities/func.ts:48

A package this function belongs to.

Returns

any

Inherited from

DataQuery.package

---

path

Get Signature

get path(): string

Defined in: src/entities/func.ts:40

Entity path

Returns

string

Inherited from

DataQuery.path

---

postProcessScript

Get Signature

get postProcessScript(): string

Defined in: src/entities/data-connection.ts:41

Returns

string

Set Signature

set postProcessScript(script): void

Defined in: src/entities/data-connection.ts:42

Parameters

Parameter	Type
script	string

Returns

void

Inherited from

DataQuery.postProcessScript

---

query

Get Signature

get query(): string

Defined in: src/entities/data-connection.ts:35

Query text

Returns

string

Set Signature

set query(q): void

Defined in: src/entities/data-connection.ts:36

Parameters

Parameter	Type
q	string

Returns

void

Inherited from

DataQuery.query

---

table

Get Signature

get table(): string

Defined in: src/entities/data-connection.ts:63

Table name

Returns

string

Set Signature

set table(tableName): void

Defined in: src/entities/data-connection.ts:64

Parameters

Parameter	Type
tableName	string

Returns

void

---

type

Get Signature

get type(): string

Defined in: src/entities/func.ts:38

Returns

string

Inherited from

DataQuery.type

---

updatedOn

Get Signature

get updatedOn(): Dayjs | null

Defined in: src/entities/entity.ts:53

Time when entity was updated *

Returns

Dayjs | null

Inherited from

DataQuery.updatedOn

---

where

Get Signature

get where(): FieldPredicate[]

Defined in: src/entities/data-connection.ts:75

Where clauses

Returns

FieldPredicate[]

Set Signature

set where(wl): void

Defined in: src/entities/data-connection.ts:76

Parameters

Parameter	Type
wl	FieldPredicate[]

Returns

void

Methods

apply()

apply(parameters?): Promise<any>

Defined in: src/entities/func.ts:79

Executes the function with the specified parameters, and returns result. If necessary, the corresponding package will be loaded as part of the call.

Parameters

Parameter	Type
parameters	any[] | {[name: string]: any; }

Returns

Promise<any>

Inherited from

DataQuery.apply

---

applySync()

applySync(parameters?): any

Defined in: src/entities/func.ts:95

Executes the function synchronously, and returns the result. If the function is asynchronous, throws an exception.

Parameters

Parameter	Type
parameters	{[name: string]: any; }

Returns

any

Inherited from

DataQuery.applySync

---

executeTable()

executeTable(): Promise<DataFrame>

Defined in: src/entities/data-connection.ts:72

Executes query

Returns

Promise<DataFrame>

Overrides

DataQuery.executeTable

---

getProperties()

getProperties(): Promise<{[index: string]: any; }>

Defined in: src/entities/entity.ts:69

Gets entity properties

Returns

Promise<{[index: string]: any; }>

Inherited from

DataQuery.getProperties

---

hasTag()

hasTag(tag): boolean

Defined in: src/entities/entity.ts:81

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery.hasTag

---

newId()

newId(): void

Defined in: src/entities/entity.ts:32

Generates new id for this entity.

Returns

void

Inherited from

DataQuery.newId

---

prepare()

prepare(parameters?): FuncCall

Defined in: src/entities/func.ts:56

Returns FuncCall object in a stand-by state

Parameters

Parameter	Type
parameters	{[name: string]: any; }

Returns

FuncCall

Inherited from

DataQuery.prepare

---

prepareAsync()

prepareAsync(parameters?): Promise<FuncCall>

Defined in: src/entities/func.ts:60

Parameters

Parameter	Type
parameters	{[name: string]: any; }

Returns

Promise<FuncCall>

Inherited from

DataQuery.prepareAsync

---

setProperties()

setProperties(props): Promise<any>

Defined in: src/entities/entity.ts:74

Sets entity properties

Parameters

Parameter	Type
props	{[index: string]: any; }

Returns

Promise<any>

Inherited from

DataQuery.setProperties

---

tag()

tag(tag): boolean

Defined in: src/entities/entity.ts:84

Adds a specified tag

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery.tag

---

toString()

toString(): string

Defined in: src/entities/entity.ts:79

Returns a string representing the object

Returns

string

Inherited from

DataQuery.toString

---

unTag()

unTag(tag): boolean

Defined in: src/entities/entity.ts:87

Removes a specified tag

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery.unTag

---

byName()

static byName(name): Func

Defined in: src/entities/func.ts:116

Returns a function with the specified name.

Parameters

Parameter	Type
name	string

Returns

Func

Inherited from

DataQuery.byName

---

create()

static create(connection): TableQuery

Defined in: src/entities/data-connection.ts:57

Creates a TableQuery

Parameters

Parameter	Type	Description
connection	DataConnection	DataConnection to query table from

Returns

TableQuery

---

find()

static find(params?): Func[]

Defined in: src/entities/func.ts:100

Returns functions with the specified attributes.

Parameters

Parameter	Type
params?	{ meta?: any; name?: string; package?: string; returnSemType?: string; returnType?: string; tags?: string[]; }
params.meta?	any
params.name?	string
params.package?	string
params.returnSemType?	string
params.returnType?	string
params.tags?	string[]

Returns

Func[]

Inherited from

DataQuery.find

---

findAll()

static findAll(params?): Promise<Func[]>

Defined in: src/entities/func.ts:107

Parameters

Parameter	Type
params?	{ meta?: any; name?: string; package?: string; returnSemType?: string; returnType?: string; tags?: string[]; }
params.meta?	any
params.name?	string
params.package?	string
params.returnSemType?	string
params.returnType?	string
params.tags?	string[]

Returns

Promise<Func[]>

Deprecated

Use find, it's the same now but does not make a server query and synchronous.

Inherited from

DataQuery.findAll

---

from()

static from(table): TableQueryBuilder

Defined in: src/entities/data-connection.ts:99

Creates TableQueryBuilder from table name

Parameters

Parameter	Type	Description
table	string	Table name

Returns

TableQueryBuilder

---

fromTable()

static fromTable(table): TableQueryBuilder

Defined in: src/entities/data-connection.ts:104

Creates TableQueryBuilder from TableInfo

Parameters

Parameter	Type	Description
table	TableInfo	TableInfo object

Returns

TableQueryBuilder