Answers

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

  July 12

  It seems to be working as expected here - the first three columns are orderable, the last three aren't.

  Could you look at that, please, and see if it helps. It would be interesting to understand the differences.

  Colin
• jdadwilson Posts: 127Questions: 30Answers: 1

  July 12

  I suppose you meant 'first TWO columns' not 'first THREE columns'.

  Here are two links to illustrate the difference.

  This page uses v1.0. Table heading includes triangles and sorting works.

  www.msholmes.org/churches

  This page uses v2.0. Table does not include triangles and sorting doesn't work.

  www.txgrayson.org/churches

  Both use the same table initialization parameters.

  So, what do I need to do to make v2.0 sort?

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

  July 12 edited July 12

  In datatables-globals.js you have disabled ordering in the default settings:

  $.extend( $.fn.dataTable.defaults, {
  
  ....
      
      ordering: false,
  

  EDIT: Either remove it from the defautls or if you want that as the default then set ordering to true in the specific Datatable.

  Kevin
• span z Posts: 4Questions: 2Answers: 0

  July 12 edited July 12

  https://www.txgrayson.org/java/vendor/datatables-globals.js
  ordering: false,

  https://www.txgrayson.org/java/churches.js
  set ordering: true,
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  July 12 Answer ✓

  https://www.txgrayson.org/java/churches.js
  set ordering: true,

  Not that I can see:

  function init_Table() {
      oTable = $('#mainTable').DataTable({
          ajax: 'assets/ajax/ajax_Churches.php',
  
          columns: [{ data: 'chu_Name', className: 'udatal', orderable: true,  visible: true },
                    { data: 'twn_Name', className: 'udatal', orderable: true,  visible: true },
                    { data: 'chu_Lat',  className: 'udatar', orderable: false, visible: true },
                    { data: 'chu_Lon',  className: 'udatar', orderable: false, visible: true },
                    { data: 'chu_Id',   className: 'udatar', orderable: false, visible: false}],
  
          pageLength: 10
      });
  }
  

  Allan
• jdadwilson Posts: 127Questions: 30Answers: 1

  July 12

  Thanks... setting orderable: true in the defaults made it work.

  jdadwilson