Answers

• kthorngren Posts: 21,330Questions: 26Answers: 4,951

  November 2021

  Use Orthogonal data. Use columns.render is shown in the Computed Values docs to return the unsigned number for the sort operation.

  Kevin
• mkhsam Posts: 2Questions: 1Answers: 0

  November 2021 edited November 2021

  Thanks, not clear how to return return the unsigned number for the sort operation and how it can sort in right order my values.
  How it looks for me now:

    <script type="text/javascript">
      $(document).ready(function() {
        $('#my_function').DataTable( {
            ajax: {"url": location.origin + '/api/v1/test_url/',
                   "dataSrc": ""},
            bPaginate: false,
            columns: [
                  {data:"results",
                   render: function ( data, type, row ) {
                          if ( type === 'sort' ) {
                                  return (data >>> 0).toString(2);
                          }
                          return data;
                  }},
                  ]
                } );
            });
    </script>
  

  What is wrong here?

  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

  November 2021 Answer ✓

  toString() wouldn't do it, you need Math.abs() - see here :

          render: function(data, type) {
            if (type === 'sort') {
              return Math.abs(data);
            }
            
            return data;
          }
  

  Colin