JQuery data filter
I have a date filter for data using a calendar image and it works great. But when I clear the date, it doesn't show all dates.
How can I make a button to display all dates that clear the date filter?
Any help / advice on this would be great, thanks in advance.
// The plugin function for adding a new filtering routine
$.fn.dataTableExt.afnFiltering.push(
function(oSettings, aData, iDataIndex){
var dateStart = parseDateValue($("#dateStart").val());
// aData represents the table structure as an array of columns, so the script access the date value
// in the first column of the table via aData[0]
var evalDate= parseDateValue(aData[3]);
if (evalDate == dateStart ) {
return true;
}
else {
return false;
}
});
// Function for converting a mm/dd/yyyy date value into a numeric string for comparison (example 08/12/2010 becomes 20100812
function parseDateValue(rawDate) {
var dateArray= rawDate.split("/");
var parsedDate= dateArray[1] + dateArray[0] + dateArray[3];
return parsedDate;
}
$(function() {
// Implements the dataTables plugin on the HTML table
var $oTable= $("#example").dataTable( {
"iDisplayLength": 20,
"oLanguage": {
"sLengthMenu": 'Show <select><option value="25">25</option><option value="50">50</option><option value="100">100</option><option value="200">200</option></select>'
},
"bJQueryUI": true,
"aoColumns": [
null,
null,
null,
{ "sType": "date" }
]
});
// The dataTables plugin creates the filtering and pagination controls for the table dynamically, so these
// lines will clone the date range controls currently hidden in the baseDateControl div and append them to
// the feedbackTable_filter block created by dataTables
$dateControls= $("#baseDateControl").children("div").clone();
$("#feedbackTable_filter").prepend($dateControls);
// Implements the jQuery UI Datepicker widget on the date controls
$('.datepicker').datepicker(
{dateFormat: 'DD, d MM, yy', showOn: 'button', buttonImage: '../images/calendar.jpg', buttonImageOnly: true}
);
// Create event listeners that will filter the table whenever the user types in either date range box or
// changes the value of either box using the Datepicker pop-up calendar
$("#dateStart").keyup ( function() { $oTable.fnDraw(); } );
$("#dateStart").change( function() { $oTable.fnDraw(); } );
});
+3
source to share
1 answer
Ok, have you tried:
$.fn.dataTableExt.afnFiltering.push(
function(oSettings, aData, iDataIndex){
var dateStart = parseDateValue($("#dateStart").val());
//if filter is empty return everything
if(dateStart === ''){
return true;
}
// aData represents the table structure as an array of columns, so the script access the date value
// in the first column of the table via aData[0]
var evalDate= parseDateValue(aData[3]);
if (evalDate == dateStart ) {
return true;
}
else {
return false;
}
});
If that doesn't work, can you post an example on jsfiddle?
EDIT - ok, the problem was parseDateValue()
which was expecting to create a date using /
. Since you want an exact match, you can omitparseDateValue()
// The plugin function for adding a new filtering routine
$.fn.dataTableExt.afnFiltering.push(
function(oSettings, aData, iDataIndex){
var dateStart = $("#dateStart").val();
//if filter is empty return everything
if(dateStart === ''){
return true;
}
// aData represents the table structure as an array of columns, so the script access the date value
// in the first column of the table via aData[0]
var evalDate= aData[3];
if (evalDate == dateStart ) {
return true;
}
else {
return false;
}
});
fiddle here http://jsfiddle.net/eMZtV/1/
+4
source to share