Would this require to purchase support? Multi Filter Select with columns treated differently

eberger

Hi Allan and others,

In your honest opinion is this request that I posted to Stack Overflow complicated enough to warrant purchasing an hour or three hours of support? http://stackoverflow.com/questions/13633005/datatables-multi-filter-select-each-column-is-treated-differently

I don't think I'll be able to do this on my own and I'd really like my giant table of a year's worth of blog post data from Wordpress to work this way. I'm really looking for code that I just paste right into my existing file.

Let me know what you think. I have a feeling that no one is going to answer me on Stack Overflow...

allan

Yes, you could purchase support and I'd do my best to help out, but let me explain the basics of what is needed, and you could give it a blast to see how you get on :-).

Lets take the Post date example as its actually relative simple.

1. Put a `select` list into the `tfoot` cell for that column which looks something like:

[code]

Monday
Tuesday
...

[/code]

2. Now all you need to do is bind a `change` event to that `select` and use fnFilter to actually do the filtering:

[code]
$('#filter_post_date').change( function () {
table.fnFilter( $(this).val() );
} );
[/code]

Sorted (or in this case, filtered) :-)

The others are similar. This example might be of use as well: http://datatables.net/release-datatables/examples/api/multi_filter_select.html

Allan

eberger

Hi Allan - thanks for this it is very helpful. I've actually made some progress on my own by viewing the source of these examples: http://jquery-datatables-column-filter.googlecode.com/svn/trunk/fixedHeader.html

However, I am stuck on two usability points:

1) There doesn't appear to be away to go back to viewing all rows after you've selected a a filter from the dropdown. You have to refresh the page which isn't ideal. A show "all" would be great.

2) The text box search sometimes only lets you input one character and then you can't continue to type your filter anymore.

Any help would be greatly appreciated.

Thanks!
Erik

allan

Hi Erik,

The column filter plug-in you linked to is a third party project, and not one that is maintained as part of the core DataTables project. I'd need to open an issue against that project if you are having issues specifically with it, as I don't know much about it and can't offer any support for it.

Regards,
Allan