TableQuery

Defined in: js-api/src/entities/data-connection.ts:48

Represents a table query

Extends

• DataQuery

Constructors

Constructor

new TableQuery(dart): TableQuery

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

Parameters

Parameter	Type
dart	any

Returns

TableQuery

Overrides

DataQuery.constructor

Properties

Property	Modifier	Type	Description	Inherited from	Defined in
aux	public	any	Auxiliary data associated with the function, not persisted (a MapBag: indexed access plus the map methods; typed any so it can be cast to a package's own shape).	DataQuery.aux	js-api/src/entities/func.ts:25
dart	public	any	-	DataQuery.dart	js-api/src/entities/entity.ts:19
options	public	object	Function options (the meta.* annotations) as key-value pairs (a MapBag: indexed access plus the map methods; typed any so it can be cast to a package's own shape).	DataQuery.options	js-api/src/entities/func.ts:27

Accessors

adHoc

Get Signature

get adHoc(): boolean

Defined in: js-api/src/entities/data-connection.ts:28

Deprecated

Use FuncCall.adHoc. Removed in 1.29.

Returns

boolean

Set Signature

set adHoc(a): void

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

Deprecated

Use FuncCall.adHoc. Removed in 1.29.

Parameters

Parameter	Type
a	boolean

Returns

void

Inherited from

DataQuery.adHoc

---

aggregations

Get Signature

get aggregations(): GroupAggregation[]

Defined in: js-api/src/entities/data-connection.ts:74

Aggregation clauses {queryPartParams}

Returns

GroupAggregation[]

Set Signature

set aggregations(wl): void

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

Parameters

Parameter	Type
wl	GroupAggregation[]

Returns

void

---

author

Get Signature

get author(): any

Defined in: js-api/src/entities/entity.ts:57

Who created entity *

Returns

any

Inherited from

DataQuery.author

---

connection

Get Signature

get connection(): DataConnection

Defined in: js-api/src/entities/data-connection.ts:37

The connection this query runs on.

Returns

DataConnection

Set Signature

set connection(c): void

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

Parameters

Parameter	Type
c	DataConnection

Returns

void

Inherited from

DataQuery.connection

---

createdOn

Get Signature

get createdOn(): Dayjs

Defined in: js-api/src/entities/entity.ts:48

Time when entity was created *

Returns

Dayjs

Inherited from

DataQuery.createdOn

---

description

Get Signature

get description(): string

Defined in: js-api/src/entities/func.ts:36

Returns

string

Set Signature

set description(s): void

Defined in: js-api/src/entities/func.ts:37

Parameters

Parameter	Type
s	string

Returns

void

Inherited from

DataQuery.description

---

entityType

Get Signature

get entityType(): string

Defined in: js-api/src/entities/entity.ts:64

Entity type name *

Returns

string

Inherited from

DataQuery.entityType

---

fields

Get Signature

get fields(): string[]

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

Fields array

Returns

string[]

Set Signature

set fields(fields): void

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

Parameters

Parameter	Type
fields	string[]

Returns

void

---

friendlyName

Get Signature

get friendlyName(): string

Defined in: js-api/src/entities/entity.ts:34

Entity friendly name

Returns

string

Set Signature

set friendlyName(x): void

Defined in: js-api/src/entities/entity.ts:35

Parameters

Parameter	Type
x	string

Returns

void

Inherited from

DataQuery.friendlyName

---

having

Get Signature

get having(): FieldPredicate[]

Defined in: js-api/src/entities/data-connection.ts:81

Having clauses

Returns

FieldPredicate[]

Set Signature

set having(wl): void

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

Parameters

Parameter	Type
wl	FieldPredicate[]

Returns

void

---

helpUrl

Get Signature

get helpUrl(): string

Defined in: js-api/src/entities/func.ts:44

Help URL.

Returns

string

Set Signature

set helpUrl(url): void

Defined in: js-api/src/entities/func.ts:46

Parameters

Parameter	Type
url	string

Returns

void

Inherited from

DataQuery.helpUrl

---

id

Get Signature

get id(): string

Defined in: js-api/src/entities/entity.ts:27

Entity ID (GUID)

Returns

string

Set Signature

set id(x): void

Defined in: js-api/src/entities/entity.ts:28

Parameters

Parameter	Type
x	string

Returns

void

Inherited from

DataQuery.id

---

inputs

Get Signature

get inputs(): Property[]

Defined in: js-api/src/entities/func.ts:76

Input parameters

Returns

Property[]

Inherited from

DataQuery.inputs

---

isVectorFunc

Get Signature

get isVectorFunc(): boolean

Defined in: js-api/src/entities/func.ts:54

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: js-api/src/entities/data-connection.ts:77

Returns

TableJoin[]

Set Signature

set joins(j): void

Defined in: js-api/src/entities/data-connection.ts:78

Parameters

Parameter	Type
j	TableJoin[]

Returns

void

---

limit

Get Signature

get limit(): number | undefined

Defined in: js-api/src/entities/data-connection.ts:89

Returns

number | undefined

Set Signature

set limit(rows): void

Defined in: js-api/src/entities/data-connection.ts:88

Parameters

Parameter	Type
rows	number | undefined

Returns

void

---

name

Get Signature

get name(): string

Defined in: js-api/src/entities/entity.ts:38

Entity short name

Returns

string

Set Signature

set name(x): void

Defined in: js-api/src/entities/entity.ts:39

Parameters

Parameter	Type
x	string

Returns

void

Inherited from

DataQuery.name

---

nqName

Get Signature

get nqName(): string

Defined in: js-api/src/entities/entity.ts:42

Entity full-qualified name

Returns

string

Inherited from

DataQuery.nqName

---

orderBy

Get Signature

get orderBy(): FieldOrder[]

Defined in: js-api/src/entities/data-connection.ts:85

Order By clauses

Returns

FieldOrder[]

Set Signature

set orderBy(wl): void

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

Parameters

Parameter	Type
wl	FieldOrder[]

Returns

void

---

outputs

Get Signature

get outputs(): Property[]

Defined in: js-api/src/entities/func.ts:81

Output parameters

Returns

Property[]

Inherited from

DataQuery.outputs

---

package

Get Signature

get package(): any

Defined in: js-api/src/entities/func.ts:49

A package this function belongs to, or null for core functions (e.g. Sin).

Returns

any

Inherited from

DataQuery.package

---

path

Get Signature

get path(): string

Defined in: js-api/src/entities/func.ts:41

Entity path

Returns

string

Inherited from

DataQuery.path

---

postProcessScript

Get Signature

get postProcessScript(): string

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

Script that post-processes the query result.

Returns

string

Set Signature

set postProcessScript(script): void

Defined in: js-api/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: js-api/src/entities/data-connection.ts:33

Query text

Returns

string

Set Signature

set query(q): void

Defined in: js-api/src/entities/data-connection.ts:34

Parameters

Parameter	Type
q	string

Returns

void

Inherited from

DataQuery.query

---

table

Get Signature

get table(): string

Defined in: js-api/src/entities/data-connection.ts:59

Table name

Returns

string

Set Signature

set table(tableName): void

Defined in: js-api/src/entities/data-connection.ts:60

Parameters

Parameter	Type
tableName	string

Returns

void

---

tags

Get Signature

get tags(): string[]

Defined in: js-api/src/entities/func.ts:62

Function tags. Every function kind carries them (scripts, queries, package functions). See also: https://datagrok.ai/help/datagrok/concepts/functions/func-params-annotation

Returns

string[]

Set Signature

set tags(tags): void

Defined in: js-api/src/entities/func.ts:63

Parameters

Parameter	Type
tags	string[]

Returns

void

Inherited from

DataQuery.tags

---

topMenu

Get Signature

get topMenu(): string | null

Defined in: js-api/src/entities/func.ts:58

The main-menu path the function is registered under (//top-menu: Bio | Analyze | MSA...), or null; the way to tell which function a menu item runs.

Returns

string | null

Inherited from

DataQuery.topMenu

---

type

Get Signature

get type(): string

Defined in: js-api/src/entities/func.ts:39

Returns

string

Inherited from

DataQuery.type

---

updatedOn

Get Signature

get updatedOn(): Dayjs | null

Defined in: js-api/src/entities/entity.ts:51

Time when entity was updated *

Returns

Dayjs | null

Inherited from

DataQuery.updatedOn

---

where

Get Signature

get where(): FieldPredicate[]

Defined in: js-api/src/entities/data-connection.ts:70

Where clauses

Returns

FieldPredicate[]

Set Signature

set where(wl): void

Defined in: js-api/src/entities/data-connection.ts:71

Parameters

Parameter	Type
wl	FieldPredicate[]

Returns

void

Methods

apply()

apply(parameters?): Promise<any>

Defined in: js-api/src/entities/func.ts:89

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: js-api/src/entities/func.ts:105

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: js-api/src/entities/data-connection.ts:67

Executes query

Returns

Promise<DataFrame>

Overrides

DataQuery.executeTable

---

getProperties()

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

Defined in: js-api/src/entities/entity.ts:67

Gets entity properties

Returns

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

Inherited from

DataQuery.getProperties

---

hasTag()

hasTag(tag): boolean

Defined in: js-api/src/entities/entity.ts:79

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery.hasTag

---

newId()

newId(): void

Defined in: js-api/src/entities/entity.ts:31

Generates new id for this entity.

Returns

void

Inherited from

DataQuery.newId

---

prepare()

prepare(parameters?): FuncCall

Defined in: js-api/src/entities/func.ts:66

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: js-api/src/entities/func.ts:70

Parameters

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

Returns

Promise<FuncCall>

Inherited from

DataQuery.prepareAsync

---

setProperties()

setProperties(props): Promise<any>

Defined in: js-api/src/entities/entity.ts:72

Sets entity properties

Parameters

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

Returns

Promise<any>

Inherited from

DataQuery.setProperties

---

tag()

tag(tag): boolean

Defined in: js-api/src/entities/entity.ts:82

Adds a specified tag

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery.tag

---

toString()

toString(): string

Defined in: js-api/src/entities/entity.ts:77

Returns a string representing the object

Returns

string

Inherited from

DataQuery.toString

---

unTag()

unTag(tag): boolean

Defined in: js-api/src/entities/entity.ts:85

Removes a specified tag

Parameters

Parameter	Type
tag	string

Returns

boolean

Inherited from

DataQuery.unTag

---

byName()

static byName(name): Func

Defined in: js-api/src/entities/func.ts:126

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: js-api/src/entities/data-connection.ts:54

Creates a TableQuery

Parameters

Parameter	Type	Description
connection	DataConnection	DataConnection to query table from

Returns

TableQuery

---

find()

static find(params?): Func[]

Defined in: js-api/src/entities/func.ts:110

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: js-api/src/entities/func.ts:117

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: the same result, synchronous, without a server query. Removed in 1.29.

Inherited from

DataQuery.findAll

---

from()

static from(table): TableQueryBuilder

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

Creates TableQueryBuilder from table name

Parameters

Parameter	Type	Description
table	string	Table name

Returns

TableQueryBuilder

---

fromTable()

static fromTable(table): TableQueryBuilder

Defined in: js-api/src/entities/data-connection.ts:97

Creates TableQueryBuilder from TableInfo

Parameters

Parameter	Type	Description
table	TableInfo	TableInfo object

Returns

TableQueryBuilder