DataTables custom filtering (range filtering) example
Preamble
There may be occasions when you wish to filter data presented to the end user in your own manner, common examples are number range filtering (in between two numbers) and date range filtering. DataTables provide an API method to add your own filtering functions, $.fn.dataTableExt.afnFiltering. This is an array of functions (push your own onto it) which will will be run at table draw time to see if a particular row should be included or not.
Live example
Rendering engine |
Browser |
Platform(s) |
Engine version |
CSS grade |
Trident |
Internet
Explorer 4.0 |
Win 95+ |
4 |
X |
Trident |
Internet
Explorer 5.0 |
Win 95+ |
5 |
C |
Trident |
Internet
Explorer 5.5 |
Win 95+ |
5.5 |
A |
Trident |
Internet
Explorer 6 |
Win 98+ |
6 |
A |
Trident |
Internet Explorer 7 |
Win XP SP2+ |
7 |
A |
Trident |
AOL browser (AOL desktop) |
Win XP |
6 |
A |
Gecko |
Firefox 1.0 |
Win 98+ / OSX.2+ |
1.7 |
A |
Gecko |
Firefox 1.5 |
Win 98+ / OSX.2+ |
1.8 |
A |
Gecko |
Firefox 2.0 |
Win 98+ / OSX.2+ |
1.8 |
A |
Gecko |
Firefox 3.0 |
Win 2k+ / OSX.3+ |
1.9 |
A |
Gecko |
Camino 1.0 |
OSX.2+ |
1.8 |
A |
Gecko |
Camino 1.5 |
OSX.3+ |
1.8 |
A |
Gecko |
Netscape 7.2 |
Win 95+ / Mac OS 8.6-9.2 |
1.7 |
A |
Gecko |
Netscape Browser 8 |
Win 98SE+ |
1.7 |
A |
Gecko |
Netscape Navigator 9 |
Win 98+ / OSX.2+ |
1.8 |
A |
Gecko |
Mozilla 1.0 |
Win 95+ / OSX.1+ |
1 |
A |
Gecko |
Mozilla 1.1 |
Win 95+ / OSX.1+ |
1.1 |
A |
Gecko |
Mozilla 1.2 |
Win 95+ / OSX.1+ |
1.2 |
A |
Gecko |
Mozilla 1.3 |
Win 95+ / OSX.1+ |
1.3 |
A |
Gecko |
Mozilla 1.4 |
Win 95+ / OSX.1+ |
1.4 |
A |
Gecko |
Mozilla 1.5 |
Win 95+ / OSX.1+ |
1.5 |
A |
Gecko |
Mozilla 1.6 |
Win 95+ / OSX.1+ |
1.6 |
A |
Gecko |
Mozilla 1.7 |
Win 98+ / OSX.1+ |
1.7 |
A |
Gecko |
Mozilla 1.8 |
Win 98+ / OSX.1+ |
1.8 |
A |
Gecko |
Seamonkey 1.1 |
Win 98+ / OSX.2+ |
1.8 |
A |
Gecko |
Epiphany 2.20 |
Gnome |
1.8 |
A |
Webkit |
Safari 1.2 |
OSX.3 |
125.5 |
A |
Webkit |
Safari 1.3 |
OSX.3 |
312.8 |
A |
Webkit |
Safari 2.0 |
OSX.4+ |
419.3 |
A |
Webkit |
Safari 3.0 |
OSX.4+ |
522.1 |
A |
Webkit |
OmniWeb 5.5 |
OSX.4+ |
420 |
A |
Webkit |
iPod Touch / iPhone |
iPod |
420.1 |
A |
Webkit |
S60 |
S60 |
413 |
A |
Presto |
Opera 7.0 |
Win 95+ / OSX.1+ |
- |
A |
Presto |
Opera 7.5 |
Win 95+ / OSX.2+ |
- |
A |
Presto |
Opera 8.0 |
Win 95+ / OSX.2+ |
- |
A |
Presto |
Opera 8.5 |
Win 95+ / OSX.2+ |
- |
A |
Presto |
Opera 9.0 |
Win 95+ / OSX.3+ |
- |
A |
Presto |
Opera 9.2 |
Win 88+ / OSX.3+ |
- |
A |
Presto |
Opera 9.5 |
Win 88+ / OSX.3+ |
- |
A |
Presto |
Opera for Wii |
Wii |
- |
A |
Presto |
Nokia N800 |
N800 |
- |
A |
Presto |
Nintendo DS browser |
Nintendo DS |
8.5 |
C/A1 |
KHTML |
Konqureror 3.1 |
KDE 3.1 |
3.1 |
C |
KHTML |
Konqureror 3.3 |
KDE 3.3 |
3.3 |
A |
KHTML |
Konqureror 3.5 |
KDE 3.5 |
3.5 |
A |
Tasman |
Internet Explorer 4.5 |
Mac OS 8-9 |
- |
X |
Tasman |
Internet Explorer 5.1 |
Mac OS 7.6-9 |
1 |
C |
Tasman |
Internet Explorer 5.2 |
Mac OS 8-X |
1 |
C |
Misc |
NetFront 3.1 |
Embedded devices |
- |
C |
Misc |
NetFront 3.4 |
Embedded devices |
- |
A |
Misc |
Dillo 0.8 |
Embedded devices |
- |
X |
Misc |
Links |
Text only |
- |
X |
Misc |
Lynx |
Text only |
- |
X |
Misc |
IE Mobile |
Windows Mobile 6 |
- |
C |
Misc |
PSP browser |
PSP |
- |
C |
Other browsers |
All others |
- |
- |
U |
Rendering engine |
Browser |
Platform(s) |
Engine version |
CSS grade |
Initialisation code
/* Custom filtering function which will filter data in column four between two values */
$.fn.dataTableExt.afnFiltering.push(
function( oSettings, aData, iDataIndex ) {
var iMin = document.getElementById('min').value * 1;
var iMax = document.getElementById('max').value * 1;
var iVersion = aData[3] == "-" ? 0 : aData[3]*1;
if ( iMin == "" && iMax == "" )
{
return true;
}
else if ( iMin == "" && iVersion < iMax )
{
return true;
}
else if ( iMin < iVersion && "" == iMax )
{
return true;
}
else if ( iMin < iVersion && iVersion < iMax )
{
return true;
}
return false;
}
);
$(document).ready(function() {
/* Initialise datatables */
var oTable = $('#example').dataTable();
/* Add event listeners to the two range filtering inputs */
$('#min').keyup( function() { oTable.fnDraw(); } );
$('#max').keyup( function() { oTable.fnDraw(); } );
} );
Other examples
Basic initialisation
Advanced initialisation
API
Data sources
Server-side processing
Ajax data source
Plug-ins
le v�lo � tampa (floride) douanes acier courb� sur ont d�voil� leur dernier projet, 1982 honda cb750 d�capotable.dirig� par mike mundy,
ADIDAS EQUIPMENT CUSHION 93 la boutique & # 8217;
Adidas Climacool Boat Lace s plus r�cente adaptation caract�ristiques l'�quipage & # 8217;
ADIDAS TUBULAR SHADOW KNIT s signature minimaliste propre conception avec la peinture gris et noir sur l'ext�rieur.ajouts comprennent un �cran prot�g� phare, red pod filtres et mono - choc springs parmi beaucoup d'autres am�liorations.
Adidas Yeezy Boost 350 V2peut - �tre la plus frappante dans le d�tail le tuyau d'�chappement est saillante sous le si�ge.ils a �t� sur un rouleau cette ann�e avec ses nombreuses collaborations et les rejets, et maintenant,
ADIDAS ORIGINALS NMD PRIMEKNIT les japonais basket brand,
ADIDAS SPRINGBLADE SCHUHE c'est prendre un retour aux sources avec une nouvelle paire de gel lyte vs.
ADIDAS TUBULAR WOMENv�tue d'un haut blanc pur nubuck le & # 8220; winter & # 8221;
ADIDAS SPRINGBLADE WOMEN SCHUHE pack publication offre une nouvelle nubuck blanc sur la simplicit� comme si�ge haut de la corde d'une semelle intercalaire,
ADIDAS CAMPUS tandis que les lacets cravate le chercher ensemble.comme toujours, la nouvelle - # 8220; hiver pack & # 8221; gel lyte v offre confort incomparable avec son gel technologie situ� dans le rembourrage intercalaire.l'asic gel lyte v & # 8220,
women's superstar adidas white & # 8221; est maintenant disponible chez les d�taillants comme quelques environ 145 $us.