TableQuery

Represents a table query

Extends

• DataQuery

Constructors

new TableQuery()

new TableQuery(dart): TableQuery

Parameters

Parameter	Type
dart	any

Returns

TableQuery

Overrides

DataQuery . constructor

Constructs

TableQuery

Source

src/entities.ts:426

Properties

Property	Modifier	Type	Inherited from
aux	public	any	DataQuery.aux
dart	public	any	DataQuery.dart
options	public	object	DataQuery.options

Accessors

adHoc

get adHoc(): boolean

Deprecated

Use FuncCall.adHoc instead *

set adHoc(a): void

Deprecated

Use FuncCall.adHoc instead *

Parameters

Parameter	Type
a	boolean

Returns

boolean

Source

src/entities.ts:406

---

aggregations

get aggregations(): GroupAggregation[]

Aggregation clauses {queryPartParams}

set aggregations(wl): void

Parameters

Parameter	Type
wl	GroupAggregation[]

Returns

GroupAggregation[]

Source

src/entities.ts:453

---

author

get author(): User

Who created entity *

Returns

User

Source

src/entities.ts:108

---

connection

get connection(): DataConnection

set connection(c): void

Parameters

Parameter	Type
c	DataConnection

Returns

DataConnection

Source

src/entities.ts:414

---

createdOn

get createdOn(): Dayjs

Time when entity was created *

Returns

Dayjs

Source

src/entities.ts:99

---

description

get description(): string

Returns

string

Source

src/entities.ts:234

---

fields

get fields(): string[]

Fields array

set fields(fields): void

Parameters

Parameter	Type
fields	string[]

Returns

string[]

Source

src/entities.ts:442

---

friendlyName

get friendlyName(): string

Entity friendly name

set friendlyName(x): void

Parameters

Parameter	Type
x	string

Returns

string

Source

src/entities.ts:85

---

having

get having(): FieldPredicate[]

Having clauses

set having(wl): void

Parameters

Parameter	Type
wl	FieldPredicate[]

Returns

FieldPredicate[]

Source

src/entities.ts:457

---

helpUrl

get helpUrl(): string

Help URL.

Returns

string

Source

src/entities.ts:241

---

id

get id(): string

Entity ID (GUID)

set id(x): void

Parameters

Parameter	Type
x	string

Returns

string

Source

src/entities.ts:77

---

inputs

get inputs(): Property[]

Input parameters

Returns

Property[]

Source

src/entities.ts:252

---

name

get name(): string

Entity short name

set name(x): void

Parameters

Parameter	Type
x	string

Returns

string

Source

src/entities.ts:89

---

nqName

get nqName(): string

Entity full-qualified name

Returns

string

Source

src/entities.ts:93

---

orderBy

get orderBy(): FieldOrder[]

Order By clauses

set orderBy(wl): void

Parameters

Parameter	Type
wl	FieldOrder[]

Returns

FieldOrder[]

Source

src/entities.ts:461

---

outputs

get outputs(): Property[]

Output parameters

Returns

Property[]

Source

src/entities.ts:257

---

package

get package(): Package

A package this function belongs to.

Returns

Package

Source

src/entities.ts:244

---

path

get path(): string

Entity path

Returns

string

Source

src/entities.ts:238

---

query

get query(): string

Query text

set query(q): void

Parameters

Parameter	Type
q	string

Returns

string

Source

src/entities.ts:411

---

table

get table(): string

Table name

set table(tableName): void

Parameters

Parameter	Type
tableName	string

Returns

string

Source

src/entities.ts:437

---

type

get type(): string

Returns

string

Source

src/entities.ts:236

---

updatedOn

get updatedOn(): null | Dayjs

Time when entity was updated *

Returns

null | Dayjs

Source

src/entities.ts:102

---

where

get where(): FieldPredicate[]

Where clauses

set where(wl): void

Parameters

Parameter	Type
wl	FieldPredicate[]

Returns

FieldPredicate[]

Source

src/entities.ts:449

Methods

apply()

apply(parameters): Promise<any>

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[] | object

Returns

Promise<any>

Inherited from

DataQuery . apply

Source

src/entities.ts:265

---

applySync()

applySync(parameters): any

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

Parameters

Parameter	Type
parameters	object

Returns

any

Inherited from

DataQuery . applySync

Source

src/entities.ts:281

---

executeTable()

executeTable(): Promise <DataFrame>

Executes query

Returns

Promise <DataFrame>

Overrides

DataQuery . executeTable

Source

src/entities.ts:446

---

getProperties()

getProperties(): Promise<object>

Gets entity properties

Returns

Promise<object>

Inherited from

DataQuery . getProperties

Source

src/entities.ts:111

---

hasTag()

hasTag(tag): boolean

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery . hasTag

Source

src/entities.ts:123

---

newId()

newId(): void

Generates new id for this entity.

Returns

void

Inherited from

DataQuery . newId

Source

src/entities.ts:81

---

prepare()

prepare(parameters): FuncCall

Returns FuncCall object in a stand-by state

Parameters

Parameter	Type
parameters	object

Returns

FuncCall

Inherited from

DataQuery . prepare

Source

src/entities.ts:247

---

setProperties()

setProperties(props): Promise<any>

Sets entity properties

Parameters

Parameter	Type
props	object

Returns

Promise<any>

Inherited from

DataQuery . setProperties

Source

src/entities.ts:116

---

tag()

tag(tag): boolean

Adds a specified tag

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery . tag

Source

src/entities.ts:126

---

toString()

toString(): string

Returns a string representing the object

Returns

string

Inherited from

DataQuery . toString

Source

src/entities.ts:121

---

unTag()

unTag(tag): boolean

Removes a specified tag

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery . unTag

Source

src/entities.ts:129

---

byName()

static byName(name): Func

Returns a function with the specified name.

Parameters

Parameter	Type
name	string

Returns

Func

Inherited from

DataQuery . byName

Source

src/entities.ts:302

---

create()

static create(connection): TableQuery

Creates a TableQuery

Parameters

Parameter	Type	Description
connection	DataConnection	DataConnection to query table from

Returns

TableQuery

Source

src/entities.ts:431

---

find()

static find(params?): Func[]

Returns functions with the specified attributes.

Parameters

Parameter	Type
params?	object
params.meta?	any
params.name?	string
params.package?	string
params.returnSemType?	string
params.returnType?	string
params.tags?	string[]

Returns

Func[]

Inherited from

DataQuery . find

Source

src/entities.ts:286

---

findAll()

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

Parameters

Parameter	Type
params?	object
params.meta?	any
params.name?	string
params.package?	string
params.returnSemType?	string
params.returnType?	string
params.tags?	string[]

Returns

Promise <Func[]>

Inherited from

DataQuery . findAll

Deprecated

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

Source

src/entities.ts:293

---

from()

static from(table): TableQueryBuilder

Creates TableQueryBuilder from table name

Parameters

Parameter	Type	Description
table	string	Table name

Returns

TableQueryBuilder

Source

src/entities.ts:467

---

fromTable()

static fromTable(table): TableQueryBuilder

Creates TableQueryBuilder from TableInfo

Parameters

Parameter	Type	Description
table	TableInfo	TableInfo object

Returns

TableQueryBuilder

Source

src/entities.ts:472