Date Picker on DataTable for filtering ? MVC4

Question

0.00/5 (No votes)

See more:

i have designed a jquery DATA-TABLE and binded my data from database everything works cool & awesome .

Now i been stuck , where the thing is i have two columns in my data table startdate and enddata . so i need to provide some filter with date-time pickers or whatever best fits the scenario to filter the rows between selected dates..

I am not sure how this can be done ? Can we perform operations on DataTable Data like we are doing for searching option on DataTable ?

Else do i need to fetch a different set of data on my selection every-time and bind to Data-table ? which i am thinking at present alternative .

Any workaround is appreciated .

Thanks & Regards

Posted 8-Apr-14 7:32am

sunil gutta

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Guruprasad.K.Basavaraju · Accepted Answer · 2014-04-08T09:18:00

Solution 1

Here is an example that you should be able to use.

http://jquery-datatables-column-filter.googlecode.com/svn/trunk/dateRange.html[^]

Posted 8-Apr-14 9:18am

Guruprasad.K.Basavaraju

Comments

sunil gutta 9-Apr-14 3:37am

yes i been through that i need some advice how to attach the COLUMNFILTER to my code which is
$(document).Ready(function(
$('#tableid').datatable({//written some content}).edittable({//written something for editing i.e sUpdateURL etc });
});
}); .. In this where i neeed to attach .COLUMNFILTER() ? ? ?
REGARDS

Guruprasad.K.Basavaraju 9-Apr-14 12:37pm

is this not what you are looking for ?

$(document).ready(function(){
$('#example').dataTable()
.columnFilter({ sPlaceHolder: "head:before",
aoColumns: [ { type: "text" },
{ type: "date-range" },
{ type: "date-range" }
]

});
});

sunil gutta 9-Apr-14 12:46pm

yes this in excat but if i keep the above code where should i keep my EDITTABLE which i placed after $('#example').dataTable().editTable({}) ?? ? i need edit & column filter mate . any suggestion
**In excat i trying to develop a datatable with editable with filters too

Guruprasad.K.Basavaraju 9-Apr-14 13:12pm

Sunil..

apply both to the Datatable..

like for instance..

var dt = $('#example').dataTable({..bla bla });
dt.edittable({..bla bla });

dt..columnFilter({ sPlaceHolder: "head:before",
aoColumns: [ { type: "text" },
{ type: "date-range" },
{ type: "date-range" }
]

});

sunil gutta 9-Apr-14 13:37pm

+Thanks mate mentioned code looks cool . will try and get back to you later in that time i am working on this issue .
WELL similarly i posted one question on datatables . i hope ur expertise will prove handy in that case . the link here :http://www.codeproject.com/Questions/756815/Jquery-Data-Table-editing

Guruprasad.K.Basavaraju 9-Apr-14 14:07pm

Goodluck.. will look at the other one today.

sunil gutta 11-Apr-14 3:44am

Hi mate soory to bother you again . some customization issue for me : please possible look into this link which is extension to this post : http://www.codeproject.com/Questions/758135/Data-table-Filter-query-Datapicker ... Ty so much for your precious time