Page Comparison

Overview

...

DataTableDictionary DataTable myDataTable.ToDictionary(columns: string, separator: string)

...

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

var employeeList = employeeTable.ToDictionary('RegistryNumber');

// employeeList now contains
// {
//    "1234" : { Id : "ABC", RegistryNumber: "1234", StartDate: ... }
//    "4567" : { Id : "DEF", RegistryNumber: "4567", StartDate: ... }
// }

var employee = employeeList.Get("12345");

Example

Using multiple columns

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

var employeeList = employeeTable.ToDictionary('Id,RegistryNumber');

// employeeList now contains
// {
//    "ABC.1234" : { Id : "ABC", RegistryNumber: "1234", StartDate: ... }
//    "DEF.4567" : { Id : "DEF", RegistryNumber: "4567", StartDate: ... }
// }

var employee = employeeList.Get("ABC.1234");

Examples

...

...

Using multiple columns

Code Block
language js
var employeeTable = $Database.Get({ Parameters : { TargetSchema : 'HR', TargetTable : 'Employee' } }); var employeeList = employeeTable.ToDictionary('Id,RegistryNumber'); // employeeList now contains // { // "ABC.1234" : { Id : "ABC", RegistryNumber: "1234", StartDate: ... } // "DEF.4567" : { Id : "DEF", RegistryNumber: "4567", StartDate: ... } // } var employee = employeeList.Get("ABC.1234");