Answers

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

  September 2019

  Hi @ambrosehundal ,

  You could either use columns.render or create a custom sorting plugin,

  Cheers,

  Colin
• ambrosehundal Posts: 2Questions: 1Answers: 0

  September 2019 edited September 2019

  Hi Colin, would this still allow me to sort by "rejected" and "approved" along with sorting by "pending' all three?

  This is the code I used
  $(document).ready(function() {
    $('#sort_table').DataTable( {
          "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
          "columns" : [
            { "data" : "status",
              "render" : "pending"
  
            }
          ]
    } );
  });
  

  I am not sure what I am doing wrong

  the column is called approval_status from the row that is coming from the db. My table column header is called "Status". Which one am I supposed to use?

  Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• colin Posts: 15,240Questions: 1Answers: 2,599

  September 2019

  You would use the name in the JSON, which I suspect would be approval_status. 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