My ng-grid is connected to a SharePoint list, but I'm facing an issue where the list returns an ID number instead of the user name when populating a field with a user name.
To solve this issue, I have created a function that converts the ID to a user name:
$scope.getUserName = function (user) {
var userId = user;
$Service.getUserById($scope, userId).done(function (data) {
$scope.userName = data.d.Title;
})
}
The problem arises when calling the function in a "cellTemplate" as I can't send the ID variable to the function:
$scope.gridOptions = {
loading: true,
enableSorting: true,
enableFullRowSelection: true,
enableRowHeaderSelection: false,
showGroupPanel: true,
columnDefs: [
{ name: "Admin", field: "AdministratorId" },
{ name: "User", field: "ApprovedById" },
{ name: "SuperUser", cellTemplate: '<div>{{grid.appScope.getUserName(<pass the id variable here>)}}{{grid.appScope.userName}}</div>' }
],
data: 'gridData'
};
I am looking for guidance on how to extract the userID from 'gridData' and pass it to my function.
Update: Here is the REST call being used:
function getListItem(listName) {
var deferred = $.Deferred();
// query the list in the host web
var url = SPAppWebUrl + "/_api/SP.AppContextSite(@target)" +
"/web/lists/getbytitle('" + listName + "')/items?" +
"@target='" + SPHostUrl + "'";
$.ajax({
url: url,
type: "GET",
headers: { "Accept": "application/json;odata=verbose" }, // return data format
success: onGetEntriesSuccess,
error: onoDataCallFailure
});
function onGetEntriesSuccess(data) {
deferred.resolve(data.d);
}
function onoDataCallFailure(data, errorcode, errorMessage) {
deferred.reject("Error: " + errorMessage);
}
return deferred;}