Skip to content

DataTableDictionary.Get

Overview

object DataTableDictionary.Get ( key )
Lookups a data table row from dictionary.

Arguments

String key Data table row key

Return Value

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.

Examples

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

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

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

See Also