Datatables bug duplicated row

johngtrs

Hi,

Do you have an idea why my last row of the first page is duplicate in the 2nd page when I'm using the pagination ? This glitch appears just in the first page i don't know why... There is a parameter to fix that ?

  $('#DataTable').DataTable({
          dom: "t<'col-lg-6 col-md-6 col-sm-6'i><'col-lg-6 col-md-6 col-sm-6'p>",
          autoWidth: false,
          serverSide: true,
          aaSorting: [[1, 'asc']],
          // filter: false,
          lengthChange: false,
          ajax: {
              url: 'path/url',
              method: 'POST'
          },
          columns: [
              {data: "number", width:"5%"},
              {data: "familyname", width:"10%"},
              {data: "firstname", width:"10%"},
              {data: "immat", width:"10%"},
              {data: "description", width:"10%"},
              {data: "category", width:"2%"},
              {data: "date", render: depdateAndPdf, width:"10%"}
          ]
  });

allan

Sounds like there might be an offset / limit issue with your server-side processing script. Given that you have server-side processing enabled, the issue isn't on the client-side in this case.

Allan

johngtrs

You right Allan :). I'm using a phalcon adapter for datatables : https://github.com/m1ome/phalcon-datatables and the problem is in the resultSet method. So I'm using the QueryBuilder method and it's work.

Thank you.