fnFilter

guillimon

Hi all.

How can i use fnFilter for filter with criteria "greater than". I think but, by defaullt, fnFilter filter the data with contains the data input. I don't hoew filter, for instead, if I introduce the numer 5, all rows whith the column greater than 5.

I search in this forum, but i find anything.

Thanks for all

allan

Hi guillimon,

You can't use fnFilter on it's own for what you are looking for - as you say, it's looking specifically for matching text. What you will need to do is create a filter plug-in. The documentation for this can be found here:
http://datatables.net/development/filtering

And there is an example similar to what you are looking for (it has a min values as well) here:
http://datatables.net/examples/api/range_filtering.html

Regards,
Allan

guillimon

Thank you. I solved the problem, so I can filter in a date range.

I have two inputs (fini and ffin) for initial date and end date (in format dd-mm-yyy) and two columns in the table (columns 6 and 7).
I have to convert all dates in format yyyymmdd and filter it,

I put the code for $.fn.dataTableExt.afnFiltering.push. Maybe is usefull for somebody.
The rest is the same like the example http://datatables.net/examples/api/range_filtering.html (be careful with the inputs id):

[code]

$.fn.dataTableExt.afnFiltering.push(
function( oSettings, aData, iDataIndex ) {

var iFini = document.getElementById('fini').value;
iFini=iFini.substring(6,10) + iFini.substring(3,5)+ iFini.substring(0,2)

var iFfin = document.getElementById('ffin').value;
iFfin=iFfin.substring(6,10) + iFfin.substring(3,5)+ iFfin.substring(0,2)


var datofini=aData[6].substring(6,10) + aData[6].substring(3,5)+ aData[6].substring(0,2);
var datoffin=aData[7].substring(6,10) + aData[7].substring(3,5)+ aData[7].substring(0,2);


if ( iFini == "" && iFfin == "" )
{
return true;
}
else if ( iFini <= datofini && iFfin == "")
{
return true;
}
else if ( iFfin >= datoffin && iFini == "")
{
return true;
}
else if (iFini <= datofini && iFfin >= datoffin)
{
return true;
}
return false;

}
);


[/code]

allan

Hi guillimon,

Nice one! Thanks very much for sharing your code with us. I've put up a new plug-ins page with your filter on it as a demonstration of how custom filtering can be done with DataTables: http://datatables.net/plug-ins/filtering

Regards,
Allan