TableQueryBuilder

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

Table query builder that works with database tables

Constructors

Constructor

new TableQueryBuilder(dart): TableQueryBuilder

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

Parameters

Parameter	Type
dart	any

Returns

TableQueryBuilder

Properties

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

Methods

avg()

avg(field, fieldAlias?): TableQueryBuilder

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

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:290

Builds a query

Returns

TableQuery

---

count()

count(fieldAlias?): TableQueryBuilder

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

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:251

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:274

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" | "bool" | "int" | "double" | "byte_array" | "datetime" | "qnum" | "dataframe" | "numerical" | "categorical" | "num" | "string_list" | "dataframe_list" | "cell" | "column" | "column_list" | "graphics" | "blob" | "tablerowfiltercall" | "colfiltercall" | "bitset" | "dynamic" | "viewer" | "list" | "semantic_value" | "func" | "funccall" | "property" | "GridCellRenderArgs" | "element" | "view" | "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:234

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:201

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	"inner" | "outer" | "left" | "right"	{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:212

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:287

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:157

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:149

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:187

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:245

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:258

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:223

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:126

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:133

Performs aggregation

Parameters

Parameter	Type	Description
type	"values" | "key" | "pivot" | "first" | "count" | "unique" | "nulls" | "min" | "max" | "sum" | "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:122

Selects all fields of the table

Returns

TableQueryBuilder

---

sortBy()

sortBy(field, asc?): TableQueryBuilder

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

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:165

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:179

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:266

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" | "bool" | "int" | "double" | "byte_array" | "datetime" | "qnum" | "dataframe" | "numerical" | "categorical" | "num" | "string_list" | "dataframe_list" | "cell" | "column" | "column_list" | "graphics" | "blob" | "tablerowfiltercall" | "colfiltercall" | "bitset" | "dynamic" | "viewer" | "list" | "semantic_value" | "func" | "funccall" | "property" | "GridCellRenderArgs" | "element" | "view" | "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:110

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:117

Creates TableQueryBuilder from TableInfo

Parameters

Parameter	Type	Description
table	TableInfo	TableInfo object

Returns

TableQueryBuilder