Has¶

Returns true if specified key value exists in the dictionary.

1

myDataTableDictionary.Has(key: string):boolean

Parameters¶

string key
    Key of value to check

Returns¶

True if key value exists in the dictionary, returns true, otherwise returns false.

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.
The following code returns value 'true' for variable name_to_check if name "John Doe" exists in the dictionary:

Example¶

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

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

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

var name_to_check = list.Has('John Doe');

See Also¶

• $Database.Get
• DataTableDictionary