`GetTableCell`

The GetTableCell type describes a function that takes a Id and returns the Cell value for a particular Row, optionally in a joined Table.

When called with one parameter, this function will return the value of the specified Cell from the query's root Table for the Row being selected or filtered.

(cellId: Id): CellOrUndefined

Type Description

	Type	Description
`cellId`	`Id`	The `Id` of the `Cell` to fetch the value for.
returns	`CellOrUndefined`	A `Cell` value or `undefined`.

cellId

Id

The Id of the Cell to fetch the value for.

returns

CellOrUndefined

A Cell value or undefined.

When called with two parameters, this function will return the value of the specified Cell from a Table that has been joined in the query, for the Row being selected or filtered.

(
  joinedTableId: Id,
  joinedCellId: Id,
): CellOrUndefined

Type Description

	Type	Description
`joinedTableId`	`Id`	The `Id` of the `Table` to fetch the value from. If the underlying `Table` was joined 'as' a different `Id`, that should instead be used.
`joinedCellId`	`Id`	The `Id` of the `Cell` to fetch the value for.
returns	`CellOrUndefined`	A `Cell` value or `undefined`.

joinedTableId

Id

The Id of the Table to fetch the value from. If the underlying Table was joined 'as' a different Id, that should instead be used.

joinedCellId

Id

The Id of the Cell to fetch the value for.

returns

CellOrUndefined

A Cell value or undefined.

A GetTableCell can be provided when setting query definitions, specifically in the Select and Where clauses when you want to create or filter on calculated values. See those methods for specific examples.

Since

v2.0.0