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
| Code Block | ||
|---|---|---|
| ||
var table = $Database.Get({
Parameters : {
TargetSchema : 'HR',
TargetTable : 'Groups'
}
});
var list = table.ToDictionary('Name');
var myGroup = list.Get("MyGroup"); |