ConglomerateRecord

ConglomerateRecord

Used to create a single row from multiple rows for GROUP BY expressions.

Constructor

new ConglomerateRecord(virtualFields)

Source:
Parameters:
Name Type Description
virtualFields Array.<TableField>

Members

selectVirtualFields

Source:
Properties:
Type Description
Array.<TableField>

Methods

squish(groupRecords) → {Array.<any>}

Description:

  • Compress group records to a single row by applying appropriate aggregate functions.

Source:
Parameters:
Name Type Description
groupRecords Array.<Array.<any>>

a group of table data records to compress.
Returns:
  • compressed record.
  • If column is not an aggregate function, value from first row of group records is selected. (should all be the same)
  • If column has aggregate function, that function is applied to all rows from group records.
Type
Array.<any>

(static) aggregateColumn(field, groupRecords, columnIndex) → {any}

Description:

  • Apply aggregate function to all rows on specified column and return result.

Source:
Parameters:
Name Type Description
field TableField

field with aggregate function
groupRecords Array.<any>

group of records we apply function to.
columnIndex Number

the column index where data is read from and function is applied on.
Returns:
  • value of aggregate function for all group rows.
Type
any

(static) aggregateColumnToNumeric(columnData) → {Number}

Source:
Parameters:
Name Type Description
columnData any
Returns:
Type
Number