...
Code Block | ||
---|---|---|
| ||
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
...
Code Block | ||
---|---|---|
| ||
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"); |
...
Code Block | ||
---|---|---|
| ||
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"); |