Answers

• colin Posts: 15,177Questions: 1Answers: 2,590

  December 2021

  Yep, Absolute is the way to go, this example here should help as it's showing how to use it. Could you look at that, please, and see if it helps. If it's still not working for you, please can you update my example, or link to your page, so that we can see the problem.

  Cheers,

  Colin
• mor2778 Posts: 3Questions: 1Answers: 0

  December 2021 edited December 2021

  hm... I see how the example works and it seems I didn't mention something important...

  my server-side is python and I'm using Jinja2 (a kind of simple alternative for let's say... React) and I'm transferring the data to the front-side as a pandas dataframe (see attached picture) - which means I can not leave an empty <td> as the example shows.

  

  and this is how it looks on the website
  

  there is any way I can work around it? thanks!

  UPDATE:
  OK, I've added the new row by adding .node() to row

  (document).ready( function () {
    var hidden = $.fn.dataTable.absoluteOrder( [
      { value: 'XXX', position: 'top' }
    ] );
  
    var table = $('#example').DataTable({
      orderFixed: {'pre': [5, 'asc']},
      columnDefs: [{
        targets: -1,
        visible: false,
        type: hidden,
      }]
    });
  
    table.row.add(['4', 'test', 'test', '33', '2011/02/02', 'YYY','XXX']).draw().node();
  });
  

  that how it looks after adding the new tow
  

  at start it sorted (new row on the top) but when I try to sort the table it just sorting regular without any freeze the first row.. what am I missing here?

  Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  December 2021

  You probably need to change orderFixed: {'pre': [5, 'asc']}, to orderFixed: {'pre': [6, 'asc']}, so the table is always sorted by the hidden column first. See the orderFixed docs for more details.

  Kevin
• mor2778 Posts: 3Questions: 1Answers: 0

  December 2021

  When I switch to 6 sorting stops working... no mater on which column header I click nothing happens...
• colin Posts: 15,177Questions: 1Answers: 2,590

  December 2021

  We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

  Cheers,

  Colin