DerivedTable

DerivedTable

The JOIN creates a new logical table.

Constructor

new DerivedTable()

Source:

Members

isOuterJoin

Source:
Properties:
Type Description
Boolean

leftField

Source:
Properties:
Type Description
TableField

leftRecords

Source:
Properties:
Type Description
Array.<Array.<Number>>

rightField

Source:
Properties:
Type Description
TableField

tableInfo

Source:
Properties:
Type Description
Table

tableInfo :Table

Source:
Type:

Methods

createTable() → {DerivedTable}

Description:
  • Create derived table from the two tables that are joined.

Source:
Returns:
Type
DerivedTable

getTableData() → {Table}

Description:
  • Get derived table info.

Source:
Returns:
Type
Table

isDerivedTable() → {Boolean}

Description:
  • Is this a derived table - one that has been joined.

Source:
Returns:
Type
Boolean

setIsOuterJoin(isOuterJoin) → {DerivedTable}

Description:
  • Indicate if outer or inner join.

Source:
Parameters:
Name Type Description
isOuterJoin Boolean

true for outer, false for inner

Returns:
Type
DerivedTable

setLeftField(leftField) → {DerivedTable}

Description:
  • Left side of join condition.

Source:
Parameters:
Name Type Description
leftField TableField
Returns:
Type
DerivedTable

setLeftRecords(leftRecords) → {DerivedTable}

Source:
Parameters:
Name Type Description
leftRecords Array.<Array.<Number>>

first index is record ID of left table, second index is a list of the matching record ID's in right table.

Returns:
Type
DerivedTable

setRightField(rightField) → {DerivedTable}

Description:
  • Right side of join condition

Source:
Parameters:
Name Type Description
rightField TableField
Returns:
Type
DerivedTable

(static) getCombinedColumnTitles(leftField, rightField) → {Array.<String>}

Description:
  • Create title row from LEFT and RIGHT table.

Source:
Parameters:
Name Type Description
leftField TableField
rightField TableField
Returns:
Type
Array.<String>