Answers

• rf1234 Posts: 2,955Questions: 87Answers: 416

  September 2022

  You could use "ajax.data" to send additional filters to the server using Editor. Not sure whether you are using Editor.

  In this code snippet I am sending various variables to the server als POST variables to limit the number of values retrieved in case I operate the table in server side mode. In case I operate the table in client side mode the filtering is done on the client but that is something you think will be too slow.

  The values I send to the server are derived from the search input and from two custom buttons. All you would need to do is to create custom buttons or a dropdown or whatevery you need and send the values to the server to limit the number of rows retrieved.

  ajax: {
      url: yourURL',
      type: 'POST',
      data: function ( d ) {   
          if ( serverSideDocSearchPage ) {
              d.fullTextSearchString = d.search.value;
              d.startDateExpired = nMonthsAgo( $('#monthsSelect').val() );
              d.showDeleted = showDeleted ? 1 : 0; //send 1 if true and 0 if false
          }
      }
  },
  

  https://datatables.net/reference/option/serverSide