chifailai2 / jquery-datatables-column-filter

Automatically exported from code.google.com/p/jquery-datatables-column-filter
0 stars 0 forks source link

Feature request: Multi-column date-range filter #79

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
N/A

What is the expected output? What do you see instead?
I'm using DataTables with Column Filter to manage when employees are on 
vacation, are sick and similar. That means I have a table with employee name, 
and then two date columns.
E.g. Paul are on vacation from July 5th to July 25th, giving me three columns: 
'Paul', '05/07/2012' and '25/07/2012'.

That two latter of the columns I've set as date ranges, giving me a 'from' and 
'to' input field for each column. I'd like those 'from' and 'to' to be spread 
over the two columns, so I can search a date range within the date range (does 
that make sense?).

I've tried just hiding two of the input fields (I hide the 'to' field in the 
first column, and the 'from' field in the second one), but that provides weird 
results, e.g.

Search for from: 05/07/2012 08:00 to: 06/07/2012 16:00 gives these results:
Paul from: 06/07/2012 08:00 -  to: 06/07/2012 16:00
Ann from: 05/07/2012 08:00 - to: 06/07/2012 15:00

However, if I search from: 06/07/2012 08:00 to: 06/07/2012 16:00, I only get:
Paul from: 06/07/2012 08:00 -  to: 06/07/2012 16:00

Which makes perfectly sense in the way column filter works now, but I'd like it 
to still show Ann's result, as one of the dates is still within the range.

Original issue reported on code.google.com by pe...@innowell.net on 30 Jul 2012 at 10:04