DataTableDictionary.Get

Overview

Lookups a data table row from dictionary.

( DataRow | Array<DataRow> ) myDataTableDictionary.Get(key: string)

Arguments

string key

Data table row key

Returns

Returns the matching object from DataTableDictionary if found, otherwise returns null.

Remarks

If key value trimmed if starts with numeric 0 characters if not contain any '.' (dot) character. For example : '00001234' key becomes '1234' but '000.1234' preserved.

If multiple rows matched with key an matching object array is returns.

Example

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

var list = table.ToDictionary('Name');

var myGroup = list.Get("MyGroup");