Answers

• tangerine Posts: 3,365Questions: 39Answers: 395

  June 2014

  What do you mean by " filter doesn't work"? It seems to me that "0" is just ignored, which is the behaviour I would expect.
• Floriane Posts: 22Questions: 6Answers: 0

  June 2014

  Yes, but if I want to search a value equals to 0 I can't, is it right ?
  Why 0 is ignored ? Where can I change this behaviour ?
• Floriane Posts: 22Questions: 6Answers: 0

  June 2014

  I can't find where this behavior is in DataTable.js ... Does someone can help me please?
• tangerine Posts: 3,365Questions: 39Answers: 395

  June 2014 edited June 2014

  You are looking at a range filter. It finds values between x and y. For values equal to x, use a different filter.
• Floriane Posts: 22Questions: 6Answers: 0

  June 2014

  I use the range filter and an equal filter. None of them works with value "0"... Like you said, the "0" is ignored.
• Floriane Posts: 22Questions: 6Answers: 0

  June 2014

  Nobody knows where I can find this behavior ?
• tangerine Posts: 3,365Questions: 39Answers: 395

  June 2014

  What do you mean by "an equal filter"? It would make more sense to show us your code so we can see what you are doing.
• allan Posts: 63,531Questions: 1Answers: 10,475 Site admin

  June 2014 Answer ✓

  Its a bug in the example rather than in DataTables. The filter does run, but the data isn't being correctly filtered out.

  If you update the custom filter to the following code it does work:

  $.fn.dataTable.ext.search.push(
      function( settings, data, dataIndex ) {
          var min = parseInt( $('#min').val(), 10 );
          var max = parseInt( $('#max').val(), 10 );
          var age = parseFloat( data[3] ) || 0; // use data for the age column
  
          if ( ( isNaN( min ) && isNaN( max ) ) ||
               ( isNaN( min ) && age <= max ) ||
               ( min <= age   && isNaN( max ) ) ||
               ( min <= age   && age <= max ) )
          {
              return true;
          }
          return false;
      }
  );
  

  I'll update the example for 1.10.1.

  Thanks,
  Allan
• Floriane Posts: 22Questions: 6Answers: 0

  June 2014

  Ok, everything works fine.

  Thanks Allan !