title: How I use multi column ordering with one column in desc?
body: <p>This is my datatable:</p>
  
  <pre><code>NAME   SORT
  Adam
  Ali    101
  David  102
  Laura
  Will
  </code></pre>
  
  <p>I try to sort my table by the column <code>name</code> and also by the column <code>sort</code>. </p>
  
  <p>The result I am looking for is:</p>
  
  <pre><code>NAME   SORT
  David  102  
  Ali    101  
  Adam
  Laura
  Will
  </code></pre>
  
  <p>This means, everything that has a sort number should sort by the column <code>sort</code> and everything else by <code>name</code>.</p>
  
  <p>This is my approach:</p>
  
  <pre><code>var table = $('.datatable').DataTable({
  "order": [[ 0, "asc" ]],
  "columnDefs": [
    {
          "targets": [ 0 ],
          "orderData": [ 0, 1 ]
        },
  ],
  ...
  </code></pre>
  
  <p>But it is not working. The columns are only sorted by <code>name</code>.
  If I change the code to:</p>
  
  <pre><code>  var table = $('.datatable').DataTable({
      "order": [[ 0, "asc" ]],
      "columnDefs": [
        {
              "targets": [ 0 ],
              "orderData": [ 1, 0 ]
            },
      ],
      ...
  </code></pre>
  
  <p>It is considering now both columns for sorting, but the second column orders in the wrong direction:</p>
  
  <pre><code>NAME   SORT
  Adam
  Laura
  Will
  Ali    101  
  David  102  
  </code></pre>