Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  November 2020

  Yep, with serverSide, the client only knows about the data displayed on the page, so anything happening before that draw will be lost. You could try using draw to get the checkboxes back in their previous condition, having saved the state in a global variable whenever select or deselect triggers,

  Colin
• kthorngren Posts: 21,336Questions: 26Answers: 4,951

  November 2020

  Not sure if you are using the Gyrocode Checkboxes library or not. You do have the configuration for it:

               'checkboxes': {
                  'selectRow': true
               } 
  

  That library will keep track of the selected rows when using server side processing. See this example. The key is the checkbox column needs to have a unique ID.

  Since its not keeping the selected rows I suspect you aren't loading the library code.

  Kevin
• D.Roger Posts: 3Questions: 1Answers: 0

  November 2020

  @kthorngren well. im using his library but i dont know why whenever i select one of the check boxes. it selecting all checkboxes when im clicking the pagination.
• D.Roger Posts: 3Questions: 1Answers: 0

  November 2020

  sir @colin well. i'm new to this and just have half a year of experience so i'm afraid i dont know how to use the drawcallback without an example.anyway thankyou i will analayze that function.
• kthorngren Posts: 21,336Questions: 26Answers: 4,951

  November 2020 edited November 2020

  im using his library but i dont know why whenever i select one of the check boxes. it selecting all checkboxes when im clicking the pagination.

  Their docs state this in the known limitations:

  Column containing checkboxes must have unique data. Using columns.data option set to null for the column containing checkboxes will result in unexpected behavior.

  You have {"data" : ""}, which is likely has the same limitation. As I mentioned previously you will need this column to have a unique key. I believe this is how it keeps track of the selected rows when using server side processing.

  For specific support of this library you will need to contact the developer. Use the Report a Bug button on the example page.

  Kevin
• Paresh10 Posts: 1Questions: 0Answers: 0

  July 2021

  I had the same problem. I am using serverside and needed the rows to be selected when paginating. Solved the issue by using 'draw' API. Thanks, Collin. Here is the example from the docs

  datatable.on( 'draw', function () {
     "Your logic should go here"
  } );
  
• Durgzozo Posts: 2Questions: 1Answers: 0

  June 2022

  $(function () {
  product_list = $('#product_list').DataTable({
  processing: true,
  serverSide: true,
  iDisplayLength: 15,
  lengthChange: false,
  info: false,
  ajax: base_path+"products",
  language: {
  processing: '

  '
  },
  columns: [
  {
  orderable: false,
  className: 'select-checkbox',
  targets: 0,
  data:'id'
  },
  {data: 'product_name' ,class: 'text-left th-name'},
  {data:'category_name', class: 'text-left'},
  {data: 'product_type', class: 'text-left'},
  {data: 'created_at'},
  {data: 'action',class: 'action-field', orderable: false, searchable: false},
  ],
  select: {
  style: 'multi',
  selector: 'td:first-child',
  },
  order: [
  [1, 'asc'],
  ],
  });
  // search in datatable
  $('#supplierList_search').keyup(function() {
  // alert($(this).val());
  product_list.search($(this).val()).draw();
  });

     $('body').on('click', '.show_confirm', function () {
        var form =  $(this).closest("form");
        var name = $(this).data("name");
        event.preventDefault();
        swal({
            title: `Are you sure you want to delete this record?`,
            text: "If you delete this, it will be gone forever.",
            icon: "warning",
            buttons: true,
            dangerMode: true,
        })
        .then((willDelete) => {
          if (willDelete) {
            form.submit();
        }
    });
  });
  
  
      $('#CheckAllButton').click(function() {
      if (product_list.rows({
              selected: true
          }).count() > 0) {
          product_list.rows().deselect();
          return;
      }
      product_list.rows().select();
  });
  
  
  
  product_list.on('select deselect', function(e, dt, type, indexes) {
      if (type === 'row') {
          if (dt.rows().count() === dt.rows({
                  selected: true
              }).count()) {
              $('#CheckAllButton i').attr('class', 'fa fa-check');
              return;
          }
          if (dt.rows({
                  selected: true
              }).count() === 0) {
              $('#CheckAllButton i').attr('class', '');
              return;
          }
          $('#CheckAllButton i').attr('class', 'fa fa-minus');
      }
  });
  

  });
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  June 2022

  @Durgzozo - Do you have a question?