Based on my discussions with LeftyX, it appears that there is no built-in method in jqGrid to achieve this. As a result, I have developed a custom function for performing a "JOIN" operation between objects in an array. The function implementation is as follows:
function joinJSONFK(entities, fkProperties, fkLookupArrays) {
function findValueInArray(array, idField, value) {
for (var i = 0; i < array.length; i++) {
if (value == array[i][idField]) {
return array[i];
}
}
return null;
};
function applyForeignKeys(entity, fkProperties, fkLookupArrays) {
for (var i = 0; i < fkProperties.length; i++) {
entity[fkProperties[i] + "Source"] = findValueInArray(fkLookupArrays[i], fkProperties[i], entity[fkProperties[i]]);
}
return entity;
}
var entityArray = [];
if (!entities instanceof Array) {
entities = applyForeignKeys(entities);
return entities[0];
} else {
for (var i = 0; i < entities.length; i++) {
entities[i] = applyForeignKeys(entities[i], fkProperties, fkLookupArrays);
}
return entities;
}
}
The usage of this function would be as indicated below:
userRoleData = joinJSONFK(result, ["SysRoleId", "BranchId"], [GlobalRoles, GlobalBranches]);
In the above example, "result" represents an array of JSON objects with the following format:
[{"entityHashCode":null,"BranchId":25,"SysRoleId":1,"SysUserId":1},
{"entityHashCode":null,"BranchId":25,"SysRoleId":2,"SysUserId":1},
{"entityHashCode":null,"BranchId":26,"SysRoleId":1,"SysUserId":1]
The array ["SysRoleId", "BranchId"] contains the foreign keys that require a "JOIN" operation, while [GlobalRoles, GlobalBranches] holds the corresponding data for these foreign keys.
For instance, the structure of GlobalRoles looks like this:
[{"Name":"Admin","SysRoleId":1,"Description":"Some description"},
{"Name":"Role 2","SysRoleId":2,"Description":"Some description"},
{"Name":"A new role","SysRoleId":3,"Description":"Some description"},
{"Name":"Another Role","SysRoleId":4,"Description":"Some description"}]
Similarly, GlobalBranches has the following structure:
[{"BranchName":"Branch 25","BranchId":25,"Description":"describe the branch"},
{"BranchName":"Branch 26","BranchId":26,"Description":"describe the branch"},
{"BranchName":"Branch 27","BranchId":27,"Description":"describe the branch"}]
Once the function is called, the resulting "userRoleData" will look similar to this:
[{"entityHashCode":null,"BranchId":25,"SysRoleId":1,"SysUserId":1,
"SysRoleIdSource":{"Name":"Admin","SysRoleId":1,"Description":"Some description"},
"BranchIdSource":{"BranchName":"Branch 25","BranchId":25,"Description":"describe the branch"}},
{"entityHashCode":null,"BranchId":25,"SysRoleId":2,"SysUserId":1,
"SysRoleIdSource":{"Name":"Role 2","SysRoleId":2,"Description":"Some description"},
"BranchIdSource":{"BranchName":"Branch 25","BranchId":25,"Description":"describe the branch"}},
{"entityHashCode":null,"BranchId":26,"SysRoleId":1,"SysUserId":1,
"SysRoleIdSource":{"Name":"Admin","SysRoleId":1,"Description":"Some description"},
"BranchIdSource":{"BranchName":"Branch 26","BranchId":26,"Description":"describe the branch"}}]
As a result, you will have a well-organized collection of objects.