Filtering data by time range ?
Filtering data by time range ?
Hi all,
I use Column Filter in an external form with DataTable, like here : http://jquery-datatables-column-filter.googlecode.com/svn/trunk/external.html
I can do a date-range, but i need to do a time range too, like [quote]From 08:00:00 to 09:00:00[/quote]
Any ideas ?
Code JS :
[code]
var oTableDetail = $('#tabDetail').dataTable();
$("#tabDetail").dataTable().columnFilter({aoColumns:[
{ type:"input", sSelector: "#usagerFilter" },
{ type: "date-range", sSelector: "#dateFilter" },
{ type:"select", sSelector: "#heureFilter" },
{ type:"select", sSelector: "#decheterieFilter" }
]}
);
[/code]
I want to replace [quote]{ type:"select", sSelector: "#heureFilter" }[/quote] by something like [quote]{ type:"time-range", sSelector: "#heureFilter" }[/quote]
Code HTML :
[code]
Filtres sur tableau
Usager
Date d'entrée
Heure d'entrée
Déchèterie
Usager
Date d'entrée
Heure d'entrée
Déchèterie
Commune
Statut
ALL MY DATA
[/code]
Thanks :)
I use Column Filter in an external form with DataTable, like here : http://jquery-datatables-column-filter.googlecode.com/svn/trunk/external.html
I can do a date-range, but i need to do a time range too, like [quote]From 08:00:00 to 09:00:00[/quote]
Any ideas ?
Code JS :
[code]
var oTableDetail = $('#tabDetail').dataTable();
$("#tabDetail").dataTable().columnFilter({aoColumns:[
{ type:"input", sSelector: "#usagerFilter" },
{ type: "date-range", sSelector: "#dateFilter" },
{ type:"select", sSelector: "#heureFilter" },
{ type:"select", sSelector: "#decheterieFilter" }
]}
);
[/code]
I want to replace [quote]{ type:"select", sSelector: "#heureFilter" }[/quote] by something like [quote]{ type:"time-range", sSelector: "#heureFilter" }[/quote]
Code HTML :
[code]
Filtres sur tableau
Usager
Date d'entrée
Heure d'entrée
Déchèterie
Usager
Date d'entrée
Heure d'entrée
Déchèterie
Commune
Statut
ALL MY DATA
[/code]
Thanks :)
This discussion has been closed.