TableQueryBuilder

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

Table query builder that works with database tables

Constructors

Constructor

new TableQueryBuilder(dart): TableQueryBuilder

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

Parameters

Parameter	Type
dart	any

Returns

TableQueryBuilder

Constructs

TableQueryBuilder

Properties

Property	Type	Defined in
dart	any	js-api/src/entities/data-connection.ts:109

Methods

avg()

avg(field, fieldAlias?): TableQueryBuilder

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

Adds an aggregation that calculates average value for the specified column.

Parameters

Parameter	Type	Default value	Description
field	string	undefined	Column name.
fieldAlias	string | null	'avg'	Name of the resulting column. Default value is agg(colName).

Returns

TableQueryBuilder

---

build()

build(): TableQuery

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

Builds a query

Returns

TableQuery

---

count()

count(fieldAlias?): TableQueryBuilder

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

Adds an aggregation that counts rows. Equivalent to count(*).

Parameters

Parameter	Type	Default value	Description
fieldAlias	string	'count'	Name of the resulting column. Default value is count.

Returns

TableQueryBuilder

---

groupBy()

groupBy(fields): TableQueryBuilder

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

Groups rows that have the same values into summary values

Parameters

Parameter	Type	Description
fields	string[]	Array of fields to group by

Returns

TableQueryBuilder

---

having()

having(field, pattern, columnType?): TableQueryBuilder

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

Adds a having clause to the query. Use only with groupBy

Parameters

Parameter	Type	Description
field	string	Field name. If you join to other tables use correct alias or table name as prefix, e.g. <table alias>.<field>
pattern	string	Pattern to test field values against
columnType?	"string" | "bigint" | "object" | "map" | "file" | "view" | "blob" | "bool" | "int" | "double" | "byte_array" | "datetime" | "qnum" | "dataframe" | "numerical" | "categorical" | "num" | "string_list" | "dataframe_list" | "cell" | "column" | "column_list" | "graphics" | "tablerowfiltercall" | "colfiltercall" | "bitset" | "dynamic" | "viewer" | "list" | "semantic_value" | "func" | "funccall" | "property" | "GridCellRenderArgs" | "element" | "TableView" | "User" | "Menu" | "Project" | "event_data" | "progressindicator" | "Credentials" | "ScriptEnvironment" | "Notebook"	Should be provided, if this builder wasn't created from TableInfo or alias is used. Defaults to TYPE.STRING

Returns

TableQueryBuilder

---

innerJoin()

innerJoin(rightTable, leftTableKeys, rightTableKeys, rightTableAlias?, leftTable?): TableQueryBuilder

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

Performs inner join operation.

Parameters

Parameter	Type	Description
rightTable	string	{string}
leftTableKeys	string[]	{string[]}
rightTableKeys	string[]	{string[]}
rightTableAlias?	string	{string}
leftTable?	string	{string}

Returns

TableQueryBuilder

---

join()

join(rightTable, joinType, leftTableKeys, rightTableKeys, rightTableAlias?, leftTable?): TableQueryBuilder

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

Performs join operation of main table or table specified in leftTable to table specified in rightTable. Specify joining fields of the main table (or table specified in leftTable) in leftTableKeys and joining fields of rightTable in rightTableKeys.

Parameters

Parameter	Type	Description
rightTable	string	{string}
joinType	"left" | "right" | "inner" | "outer"	{JoinType}
leftTableKeys	string[]	{string[]}
rightTableKeys	string[]	{string[]}
rightTableAlias?	string	{string} - use to specify desired alias for the joining table and apply this alias to fields specified in select.
leftTable?	string	{string}

Returns

TableQueryBuilder

---

leftJoin()

leftJoin(rightTable, leftTableKeys, rightTableKeys, rightTableAlias?, leftTable?): TableQueryBuilder

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

Performs left join operation.

Parameters

Parameter	Type	Description
rightTable	string	{string}
leftTableKeys	string[]	{string[]}
rightTableKeys	string[]	{string[]}
rightTableAlias?	string	{string}
leftTable?	string	{string}

Returns

TableQueryBuilder

---

limit()

limit(n): TableQueryBuilder

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

Selects limited number of records

Parameters

Parameter	Type	Description
n	number	Number of records to select

Returns

TableQueryBuilder

---

max()

max(field, fieldAlias?): TableQueryBuilder

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

Adds an aggregation that calculates maximum value for the specified column.

Parameters

Parameter	Type	Default value	Description
field	string	undefined	Column name.
fieldAlias	string | null	'max'	Name of the resulting column. Default value is agg(colName).

Returns

TableQueryBuilder

---

min()

min(field, fieldAlias?): TableQueryBuilder

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

Adds an aggregation that calculates minimum value for the specified column.

Parameters

Parameter	Type	Default value	Description
field	string	undefined	Column name.
fieldAlias	string | null	'min'	Name of the resulting column. Default value is agg(colName).

Returns

TableQueryBuilder

---

nulls()

nulls(field, fieldAlias?): TableQueryBuilder

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

Adds an aggregation that counts rows with null values

Parameters

Parameter	Type	Default value	Description
field	string	undefined	Column name.
fieldAlias	string | null	'nulls'	Name of the resulting column. Default value is agg(colName).

Returns

TableQueryBuilder

---

outerJoin()

outerJoin(rightTable, leftTableKeys, rightTableKeys, rightTableAlias?, leftTable?): TableQueryBuilder

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

Performs outer join operation.

Parameters

Parameter	Type	Description
rightTable	string	{string}
leftTableKeys	string[]	{string[]}
rightTableKeys	string[]	{string[]}
rightTableAlias?	string	{string}
leftTable?	string	{string}

Returns

TableQueryBuilder

---

pivotOn()

pivotOn(fields): TableQueryBuilder

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

Rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output

Parameters

Parameter	Type	Description
fields	string[]	Array of fields to pivot on

Returns

TableQueryBuilder

---

rightJoin()

rightJoin(rightTable, leftTableKeys, rightTableKeys, rightTableAlias?, leftTable?): TableQueryBuilder

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

Performs right join operation.

Parameters

Parameter	Type	Description
rightTable	string	{string}
leftTableKeys	string[]	{string[]}
rightTableKeys	string[]	{string[]}
rightTableAlias?	string	{string}
leftTable?	string	{string}

Returns

TableQueryBuilder

---

select()

select(fields): TableQueryBuilder

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

Selects specified fields of the table. All fields will be selected if not provided.

Parameters

Parameter	Type	Description
fields	string[]	Array of fields to select

Returns

TableQueryBuilder

---

selectAggr()

selectAggr(type, field, fieldAlias): TableQueryBuilder

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

Performs aggregation

Parameters

Parameter	Type	Description
type	"values" | "max" | "key" | "min" | "sum" | "pivot" | "first" | "count" | "unique" | "nulls" | "med" | "avg" | "stdev" | "variance" | "skew" | "kurt" | "q1" | "q2" | "q3" | "#selected"	Aggregation type.
field	string | null	Column name.
fieldAlias	string | null	Name of the resulting column. Default value is agg(colName).

Returns

TableQueryBuilder

---

selectAll()

selectAll(): TableQueryBuilder

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

Selects all fields of the table

Returns

TableQueryBuilder

---

sortBy()

sortBy(field, asc?): TableQueryBuilder

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

Sorts results in ascending or descending order

Parameters

Parameter	Type	Default value	Description
field	string	undefined	Field to sort based on
asc	boolean	true	Sort in ascending order

Returns

TableQueryBuilder

---

sum()

sum(field, fieldAlias?): TableQueryBuilder

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

Adds an aggregation that calculates sum of the values for the specified column.

Parameters

Parameter	Type	Default value	Description
field	string	undefined	Column name.
fieldAlias	string | null	'sum'	Name of the resulting column. Default value is agg(colName).

Returns

TableQueryBuilder

---

valueCount()

valueCount(field, fieldAlias?): TableQueryBuilder

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

Adds an aggregation that counts rows for the specified column. Equivalent to count(field).

Parameters

Parameter	Type	Default value	Description
field	string	undefined	Column name.
fieldAlias	string	'count'	Name of the resulting column. Default value is count.

Returns

TableQueryBuilder

---

where()

where(field, pattern, columnType?): TableQueryBuilder

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

Adds a where clause to the query.

Parameters

Parameter	Type	Description
field	string	Field name. If you join to other tables use correct alias or table name as prefix, e.g. <table alias>.<field>
pattern	string	Pattern to test field values against
columnType?	"string" | "bigint" | "object" | "map" | "file" | "view" | "blob" | "bool" | "int" | "double" | "byte_array" | "datetime" | "qnum" | "dataframe" | "numerical" | "categorical" | "num" | "string_list" | "dataframe_list" | "cell" | "column" | "column_list" | "graphics" | "tablerowfiltercall" | "colfiltercall" | "bitset" | "dynamic" | "viewer" | "list" | "semantic_value" | "func" | "funccall" | "property" | "GridCellRenderArgs" | "element" | "TableView" | "User" | "Menu" | "Project" | "event_data" | "progressindicator" | "Credentials" | "ScriptEnvironment" | "Notebook"	Should be provided, if this builder wasn't created from TableInfo or alias is used. Defaults to TYPE.STRING

Returns

TableQueryBuilder

---

from()

static from(table, connection?): TableQueryBuilder

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

Creates TableQueryBuilder from table name

Parameters

Parameter	Type	Description
table	string	Table name
connection?	string | DataConnection	DataConnection that TableQuery will use after the build. Can be passed lately directly to TableQuery.

Returns

TableQueryBuilder

---

fromTable()

static fromTable(table): TableQueryBuilder

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

Creates TableQueryBuilder from TableInfo

Parameters

Parameter	Type	Description
table	TableInfo	TableInfo object

Returns

TableQueryBuilder