custom searching for a date range, with multiple fields and multiple tables

custom searching for a date range, with multiple fields and multiple tables

CharleyCharley Posts: 62Questions: 16Answers: 0

unfortunately, I don't have a test case that I can link right now (I'll see if I can put one together)

I'm using datatables on a plethora of pages, often multiple per page. I'm doing the column based filtering, which works fine for most types of fields but for dates, it would be really handy to be able to add date range filtering instead of a single text matching filter.

some of my pages are working server side, so I can handle that with the existing column filtering with a specific server side fix to handle min:11/22/2001;max:11/22/2001

other page are working client side (with data populated via velocity template), so

I've looked at a couple of examples:
https://datatables.net/forums/discussion/41003/fn-datatable-ext-search-push
https://datatables.net/manual/plug-ins/search

I have most of these pages set up to use session state, which works great with column filtering. But the above examples look like they're global and don't seem to apply to queries sent via col.search( searchVal ).draw();

can I override the column filtering for a specific table so that if the data comes in with a min and max values, I can apply date filtering to it inside of that range? If so, any suggestions for where to start fiddling with that?

Answers

Sign In or Register to comment.