Get current logged in user from SharePoint and filter DataTable with it

Katia_LT

I draw DataTable in successFunction using data from ajax call:

function loadListItems() {
        var oDataUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('orders')/items?$select=ID,Title";
        $.ajax({
                url: oDataUrl,
                type: "GET",
                dataType: "json",
                headers: {
                        "accept": "application/json;odata=verbose"
                },
                success: successFunction,
                error: errorFunction
        });
        
}

I get current SP user with this code:

var userid= _spPageContextInfo.userId;
var requestUri = _spPageContextInfo.webAbsoluteUrl + "/_api/web/getuserbyid(" + userid + ")";
var requestHeaders = { "accept" : "application/json;odata=verbose" };
$.ajax({
url : requestUri,
contentType : "application/json;odata=verbose",
headers : requestHeaders,
success : onSuccess,
error : onError
});
function onSuccess(data, request){
var user = data.d.Title;
console.log(user);
}
function onError(error) {
console.log("error");
}

Now how to draw a table and use this user var in table search?

$('#example').DataTable({
    search: {search: user}
});

I guess I need to combine these two ajax calls into one and then use this user var but not sure how to do it.

allan

You've got two async actions there - getting the data and loading the user id. So the correct answer will depend upon a number of factors. Firstly, do you get the user before creating the table (i.e. will the table only initialise after the user has been obtained) or are they truly async next to each other?

If they are, then you need to account for the case where the table is loaded before the user and also for when the user is loaded before the user.

What you have is the correct way for if you have the user first. If you have the table first and then the user, then you can use the search() method.

Allan

Katia_LT

Actions are truly async, when there is no user in the table to filter it by, table wouldn't filter and show all the data, but if in the table is user which is current logged in user, than table will be filtered by the user.

allan

Perfect - thanks. In that case:

1. When initialising the DataTable, check if the user has been loaded. If so, apply the search. Otherwise don't.
2. When the user is loaded, check if the DataTable exists. If so, apply the search to it. Otherwise just set a variable so the DataTable initialisation can see it.

Allan

Katia_LT

Thanks for the reply. Could you please show me an example on how to do it?

I don't understand how to get a user from ajax call and use this user as filter value in DataTable initialisation...

allan

Set it to a global variable (or some other scope that both actions have access to):

var user = '';

function onSuccess(data, request) {
  user = data.d.Title;
}

Then you just keep the code you have above:

$('#example').DataTable({
    search: {search: user}
});

Additionally your onSuccess to check for the existing DataTable would be:

function onSuccess(data, request) {
  user = data.d.Title;

  if (DataTable.isDataTable('#example')) {
    let table = $('#example').DataTable();

    table.search(user).draw();
  }
}

Allan