Replies

• allan Posts: 63,195Questions: 1Answers: 10,412 Site admin

  May 2013

  This can occur when you have a different number of columns in the header, from those number in the body. Also if you use aoColumns or aoColumnDefs to supply information about columns which don't exist.
  
  Allan
• RemyHouard Posts: 7Questions: 0Answers: 0

  May 2013

  Thank you for your swift reply.
  
  [quote]This can occur when you have a different number of columns in the header, from those number in the body. ...[/quote]
  Yeah I recognise the error when my table had an extra column. It's no longer the case as demosntrated here (without the aoColumns definition):
  http://sistema.chezremy.com.br/?site=mm&do=playground&udo=data-tables-test-working
  
  [quote]... Also if you use aoColumns or aoColumnDefs to supply information about columns which don't exist.[/quote]
  So the problem lies in the aoColumns declaration. The table contais 20 columns and I declared 12 in aoColumns so it can't be that I declared too many...
  
  Can you see anything wrong with it?
  [code]
  
  jQuery.extend( jQuery.fn.dataTableExt.oSort, {
  'date-eu-pre': function ( date ) {
  var date = date.replace(' ','');
  
  if (date.indexOf('.') > 0) {
  /*date a, format dd.mn.(yyyy) ; (year is optional)*/
  var eu_date = date.split('.');
  } else {
  /*date a, format dd/mn/(yyyy) ; (year is optional)*/
  var eu_date = date.split('/');
  }
  
  /*year (optional)*/
  if (eu_date[2]) {
  var year = eu_date[2];
  } else {
  var year = 0;
  }
  
  /*month*/
  var month = eu_date[1];
  if (month.length == 1) {
  month = 0+month;
  }
  
  /*day*/
  var day = eu_date[0];
  if (day.length == 1) {
  day = 0+day;
  }
  
  return (year + month + day) * 1;
  },
  
  'date-eu-asc': function ( a, b ) {
  return ((a < b) ? -1 : ((a > b) ? 1 : 0));
  },
  
  'date-eu-desc': function ( a, b ) {
  return ((a < b) ? 1 : ((a > b) ? -1 : 0));
  }
  } );
  
  /* Create an array with the values of all the input boxes in a column */
  $.fn.dataTableExt.afnSortData['dom-text'] = function ( oSettings, iColumn )
  {
  return $.map( oSettings.oApi._fnGetTrNodes(oSettings), function (tr, i) {
  return $('td:eq('+iColumn+') input', tr).val();
  } );
  }
  
  /* Create an array with the values of all the select options in a column */
  $.fn.dataTableExt.afnSortData['dom-select'] = function ( oSettings, iColumn )
  {
  return $.map( oSettings.oApi._fnGetTrNodes(oSettings), function (tr, i) {
  return $('td:eq('+iColumn+') select', tr).val();
  } );
  }
  
  /* Create an array with the values of all the checkboxes in a column */
  $.fn.dataTableExt.afnSortData['dom-checkbox'] = function ( oSettings, iColumn )
  {
  return $.map( oSettings.oApi._fnGetTrNodes(oSettings), function (tr, i) {
  return $('td:eq('+iColumn+') input', tr).prop('checked') ? '1' : '0';
  } );
  }
  
  $('#admin-financeiro-lancamento-search-return').dataTable({
  'bPaginate': false
  ,'bJQueryUI': true
  ,'sPaginationType': 'full_numbers'
  ,'oLanguage': {
  'sUrl': '/inc/DataTables/pt-br.txt'
  }
  ,'aoColumns': [
  null,
  null,
  null,
  null,
  null,
  null,
  { 'sSortDataType': 'dom-checkbox' },
  null,
  { 'sSortDataType': 'date-eu' },
  { 'sSortDataType': 'date-eu' },
  null,
  { 'sSortDataType': 'date-eu' }
  ]
  ,'bPaginate': false
  ,'bStateSave': false
  ,'sDom': '<"top"<"clear">>rt<"bottom"iflp<"clear">>'
  ,'aaSorting': [[0,'desc']]
  });
  
  [/code]
• allan Posts: 63,195Questions: 1Answers: 10,412 Site admin

  May 2013

  DataTables assumes that what is given in aoColumns is correct. So if you give it 12, but there are actually 20 - odd things are going to happen (I can't say what - its undefined!).
  
  You need to specify aoColumns accurately if you are going to use it. If you want to specify options for only some columns, use the aoColumnDefs option and target the columns you want (for example you could add a class to those you want to be EU date sorted).
  
  Allan
• RemyHouard Posts: 7Questions: 0Answers: 0

  May 2013

  Hello Allan,
  
  Ok so define all columns in aoColumns. Did that, completed them with null.
  I no longer get an error and checkbox sorting works like a charm.
  
  However date is still sorting as string instead of date.
  I'm using the function in my previous post taken from the plugins page.
  Is that the correct code to use?
  
  I updated the example page and debug code: uresuy
  
  Thanks again