tableFilter Beta 2 is live
I just uploaded a new version of the tableFilter. It would have been sooner but I’ve been trying to resolve performance issues with IE. I was successful for smaller tables, but it chokes on the large table demo with one of the plugins. Hmm, nice segue…
This release adds support for plugins though that architecture needs to be refined more. The first 2 plugins are at the proof-of-concept stage:
- Aggregator adds a row that automatically aggregates numeric columns - sum/avg/min/max. The top row shows you the aggregates for the page you’re on, the bottom shows aggregates for all filtered rows. An example of where this might be useful would be an accountant wanting to see a total of all transactions in 2005 - filter by year first, then the bottom row shows the totals. You can switch between sum/avg/min/max using the menu.
- ColumnStyles allows you to apply CSS styles to entire columns on the fly. It’s a bit cheesy at the moment, but it seems to work well, though I can’t get it to work in IE on the large demo table because of problems with IE when applying class names. I’ll create a second post about those issues separately in case someone else can benefit from what I’ve been through. I’m hoping for a solution to the problems sometime soon, but at the moment the solution is to use FireFox.
You can enable and interact with these plugins from the menu in the bottom row (which looks like crap in IE, of course).
On the list is to add more configurability, document more of the code, especially the plugins, clean up the plugin architecture more and continue refining, though I’m going to take a break for a couple of weeks. I’m fried after trying to get IE to work properly and giving up depresses me 
If you have anything specific you need added or have ideas for other plugins or suggestions for improving what is already there please let me know.
The demo is here: http://ideamill.synaptrixgroup.com/jquery/tablefilter/tabletest.htm
Trackbacks
Use this link to trackback from your own site.
Good work but I still want to see my comparison(?) operators in the the number columns.
>15
>=15
15-20
20
Hmm… seems the comment system stripped my greater than and less than marks on some stuff. Here’s the complete list:
gt15
gt=15
15-20
lt20
lt=20
lt15, gt20
Yeah it’s on my list
It will be very nice to have a print friendly button….:-P
I just added comparators for numeric columns and updated the demo. Check it out and let me know what you think. Those fields are a little more restrictive now, btw. No non-numeric characters except for >
@Oscar - I’ll see if I can do some magic with CSS, but it’s not my top priority right now
the demo looks really cool! this would be a very good solution for a spreadsheet i’m working on. where can i download the jquery file? i can download the packed version off the demo page but if the original js files are available, that would be even better. thanks!
That’s really amazing. I love your stuff and congratulate you so much that you can’t imagine it
Some are never satisfied, but me I am.
Great work !!!
ps: french speaker, sorry for my poor english;
This is really amazing. Great work!
I do have one suggestion: I believe the option to filter columns via a DROP-DOWN LIST would add a lot of functionality. The values for the list would be taken from the values of the column to which it belongs.
To extend this to YOUR example, Daemach, your ContractTitle column would be filtered by a list whose values would include: Accounting Manager, Assistant Sales Agent, Assistant Sales Representative, Marketing Assistant, Marketing Manager, etc.
Oh, I didn’t see your larger examples. Nice work!
Hey! Great
work, I just discovered this today and I am probably going to extend it a bit more next week. If you are interested I’ll send you a copy.
Basically I tweaked it to sort based on a column attribute, rather then the content - for example to provide “correct” sorting for dates (which are obviously formatted and shown like “Today”, “Yesterday”, “Wednesday, 6th July 2007″ and so forth) and a couple other things.
You jumpstarted me! Thanks again!
Nice plugin - it works, but only half for me.
Not all columns are showing the input element for filtering.
I’m trying to use this in one of my sites, but I’m running into errors in the daemoch tools script. Is the source for that available anywhere?
Thanks!
nice work.
but have you every tried to use tablefilter with jQuery.noConflict(); ?
i’m not able to use it in this way.
in the demo, you cannot use the number keys in the number pad to change either the page number or the number of rows per page at the bottom of the table. I can only assume that it’s hard coded for the number keys above qwerty…
btw, i’m using ff 2.0.4 on win xp.
@dantan: Are you saying the demo doesn’t look correct for you? If you’re talking about code on another site do you have a link so I can take a look?
@Joshua: If you’re using all of the files (especially the jquery.js file) that I included in the zip you shouldn’t have any problems. That being said, I’m hoping to release the daemachtools code soon. I’m incredibly busy on another project right now.
@Roland: I haven’t tried that, but will.
@David: Thanks for the heads up. It’s fixed in my test version here but I haven’t uploaded it yet.
nice work!
I meet the same problem with Joshua
It seems that i must define the background color of .header.
It works now.
It is a big problem that it can’t work in conflict mode
Thanks for your share!
Another problem mention by dantan: Not all columns are showing the input element for filtering.
Does it automatically parse the table and generate the input element according to the data of the table?
It’s a strange design in my opinion
Yes, at the moment it automatically parses the table. If it finds exactly the same value (or blank) in every table cell in the column it won’t show a filter element - no need to filter a column that has a single value in it.
As soon as I’m able, you will be able to override all of this, forcing columns to specific datatypes and electing to sort/filter as you wish. I’m swamped on other projects right now so this has to wait for the moment.
superb. even better than Riks quicksearch i’d say!
will have a play around with this later!
Nice work mate … i ll use it to a new open source cms i m going to develop