Answers

• tangerine Posts: 3,365Questions: 39Answers: 395

  April 2017 Answer ✓

  Server-side parameters are explained in the docs.
  https://datatables.net/manual/server-side
• tableguy Posts: 5Questions: 3Answers: 0

  April 2017 edited April 2017

  Thanks for the response, tangerine. The key is { serverSide: true } so that it includes the parameters in the query string for GET or in the body for POST.

  The only obstacle at this point seems to be how the API requires knowledge of the columns prior to retrieving the data. I am going to post that as another question.

  Here's my code for anyone else who may benefit from it:

  var resultsTable = $('#results').DataTable({
      serverSide: true,
      ajax: {
          type: "GET",
          url: "@Url.Content("~/api/search/")" + getEntityType(),
          data: function (data) {
              //This code intercepts the parameters sent to
              //the server so I can return custom parameters
              //to match those of my service endpoint
              var page = data.Start / data.length;
              var params = {
                  query: getQuery(),
                  page: isNaN(page) ? 0 : page,
                  resultsPerPage: data.length
              };
              return params;
          },
          dataSrc: function (d) {
              //I attempt to set the columns dynamically here, but
              //it doesn't seem to work.  Will ask separate question
              resultsTable.columns = getColumnsFromJson(d.Results);
              return d.Results;
          }
      }
  });