DataTable JS Unable to Filter on Column With Decimals

Question

I want to enable filtering on a DataTable column that has numbers with decimals. I am able to have the code successfully run on a table without decimals, but it cannot sort with decimal numbers. Any way to modify the below to accommodate decimals?

/* Custom filtering function which will search data in column four between two values */
        $.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[1] ) || 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;
            }
        );

        $(document).ready(function() {
            var table = $('#example').DataTable();

            // Event listener to the two range filtering inputs to redraw on input
            $('#min, #max').keyup( function() {
                table.draw();
            });
        });

I am wondering if changing the parseInt from the min and max variables to parseFloat will work, but then I am not sure if I need to modify isNaN?

Answer 1

parseInt on the min and max variables should be changed to parseFloat to enable filtering on decimal values, since parseInt returns numbers with decimals as NaN.

Answer 2

For that column you can use Datatables filter attribute

"data-filter"

<td data-filter="62,5">62.5</td>

and then in search column replace deciman "." with ","

if(colIdx == 5){
       var searchval = this.value.replace(".",",");
}else{
      var searchval = this.value;
}

colIdx is column id because i used custom search fileds

you can directly use var searchval = this.value.replace(".",",");