Answers

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

  October 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
• miltont Posts: 22Questions: 8Answers: 0

  October 2021

  I can't post a test case as it will not work because of the error.

  This part works fine:

   <script>
             $(document).ready( function () {
             $('#myTable').DataTable(
                 {
                   "order":[[1,"desc"],[2,"desc"],[3,"desc"],[4,"desc"]],                         
                   "dom":<lif<t>p>',                                   
                   lengthMenu: [[100,10,25,50,- 1],[100,10,25,50,"All"]], 
                   fixedHeader:{headerOffset:80
                 }
             );
             } );
     </script>
  

  When I alter it by adding the columnDefs I get an error and the table does not display correctly:

     <script>
              $(document).ready( function () {
              $('#myTable').DataTable(
                  {
                    "order":[[1,"desc"],[2,"desc"],[3,"desc"],[4,"desc"]],
                    "dom":<lif<t>p>',                                    
                    lengthMenu: [[100,10,25,50,- 1],[100,10,25,50,"All"]],  
                    fixedHeader:{headerOffset:80} 
                    columnDefs: [
                  {
                      targets: -1,
                      className: 'dt-body-right'}
                        ]
                                         );
              } );
        </script>
  
• kthorngren Posts: 21,330Questions: 26Answers: 4,951

  October 2021 edited October 2021 Answer ✓

  Guessing you are getting a syntax error. Looks like you need a comma and a right brace:

  $(document).ready( function () {
    $('#myTable').DataTable(
      {
        "order":[[1,"desc"],[2,"desc"],[3,"desc"],[4,"desc"]],                        
        "dom":'<lif<t>p>',                                  
        lengthMenu: [[100,10,25,50,- 1],[100,10,25,50,"All"]],
        fixedHeader:{headerOffset:80},  // comma here
        columnDefs: [
            {
               targets: -1,
               className: 'dt-body-right'
            }
         ]
  
      }. // Also missing this bracket
    );
  } );
  

  Kevin
• miltont Posts: 22Questions: 8Answers: 0

  October 2021

  Thankyou kthorngren, that addressed my error.

  What syntax would I use to mix the column alignments?

  i.e.
  targets: 0, className: 'dt-body-left'
  targets: 1,2,3,5,6,7,8,9, className: 'dt-body-center'
  targets: 4, className: 'dt-body-right'
• kthorngren Posts: 21,330Questions: 26Answers: 4,951

  October 2021 Answer ✓

  See the Conflict resolution section of the columnDefs docs for details of how to provide multiple targets.

  Kevin
• miltont Posts: 22Questions: 8Answers: 0

  October 2021

  Thanks Kevin, that did the trick!