Skip to content

Get

Looks up a data table row from the dictionary.

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

Parameters

string key
    The data table row key.

Returns

The matching DataRow object from the DataTableDictionary if found; otherwise, null.

Remarks

If the key value starts with numeric 0 characters and does not contain any '.' (dot) character, the key value is trimmed. For example: '00001234' becomes '1234', but '000.1234' is preserved.
If multiple rows match the key, an array of matching DataRow objects is returned.

Example

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
var table = $Database.Get({
    Parameters : {
        TargetSchema : 'HR',
        TargetTable : 'Groups'
    }
});

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

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

See Also