DataTable.Map

Overview

Converts all rows in table to return value of given callback function.

Array<any> myDataTable.Map(fn: (row: DataRow) => any)

Converts all rows in table to return value of given callback function.

Array<any> myDataTable.Map(fn: (row: DataRow, i: number) => any)

Arguments

(row: DataRow) => any fn

Function to call for every data row.

Remarks

If callback is null, error is thrown.

Example

Convert all rows

var table = $Database.Get({
    Parameters : {
        TargetSchema : 'HR',
        TargetTable : 'Groups'
    }
});

var allRows = table.Map(function (row) {
    return {
        id : row.Id,
        name : row.Name
    };
});

// allRows is now [ {id:123, name:xxx}, {id:456, name:yyy}]