Does anyone know of a jQuery grid plugin with filterable columns?
Obviously there are lots of jQuery grid plugins out there, and discussions of the best ones on StackOverflow, but I can't find one with filterable columns.
Here's an example of what I mean by filterable columns: see this page on The Guardian.
Note how at the top of each column there is a drop-down with a list of the possible filters, and counts by each one.
This gives you an immediate sense of the filters available and the relative importance of each one.
SlickGrid looks exciting, and appears to support some filtering - see this example - but it's not quite what I'm looking for. The filtering example asks you to enter a term in the title, but with 50,000 rows it's too difficult to know which titles are available, or whether one title is 100 times mor开发者_运维知识库e common than another - so it's not an intuitive way to explore data you don't know well.
Any ideas?
The best filtering table is Watable. I haven't found any other plugin which does number filtering.
Check ShieldUI's Filtering and Search by Filtering demos - this is what you need.
Have a look at jqGrid and expecially at its FilterToolbar sample (you will find a sample under "New in version 3.3" named "Multiple Toolbar Search" on the Demo page)
Here is the wiki page. Please look for filterToolbar
mehod.
It is exactly as in your sample.
I've dealt with grids and jQuery in a number of projects and we've always ended up using jqGrid. It can be a complex beast to master, and documentation can be tricky to sniff out, if you (and we always end up doing this) stray too far off reservation but it is powerful.
精彩评论