To give you some ideas on what I'm looking for:
The project I'm working deals with a large amount of tabular data. I am
looking for an easy way to bind sorting/filtering to the tables they work
with that would allow someone to filter by month/year in a column that
contains dates in a predefined format (2 dropdown lists), by typing in some
search criteria in another column (text field - similar to autocomplete
functionality), by a boolean in another column (checkbox), etc. Ideally you
could filter by all or any combination while retaining sorting/pagination
and striping.
As a shot in the dark, something like the following would be intuitive for
me. Perhaps a thead row would contain column names as a reference?
$("table").mattsTables({ // TableWide options
oncolorclass: "oncolor",
offcolorclass: "offcolor",
overcolorclass: "overcolor",
pagination: "simple|elaborate|silly",
recordsperpage: 50,
clearformfieldsonhiderow: true,
etc: other table options
} , { // Column options
name: {sortable:true, datatype:"text", filter:true, filtertype:"search"},
//maps to the column that contains "name" in thead
dateofbirth: {sortable:true, datatype:"date",filter:true, filtertype:
"mm/yyyy" //creates 2 dropdowns },
distancefromoffice: {sortable:true, datatype:"int|decimal|numeric",
filter:true},
favoritecolor: {sortable:true, datatype:"text",filter:true, filtertype:
"compile|somebetterterm" //creates a dropdown with all of the values in this
column automagically },
specialcolumn: {sortable:true, datatype:"custom", filter:true, filtertype:
function(){somecustomfilteringfunctiongoeshere(); }},
});
I don't know how well your DOM script would map to something like this, but
this would be very cool.
matt-51 wrote:
>
>> Matt, are you reading this list?
>
> Yes.
>
>> I am anxiously awaiting the jQuery port of
>> your table filtering/sorting functionality. Is this coming soon?
>
> Within a week or so, I hope.
> http://www.JavascriptToolbox.com/lib/tablenew/
> is where it's at right now.
>
> I'm a bit torn about how much actual jQuery-specific functionality to add
> to
> it, since the primary goal is to be unobtrusive and simply add class names
> to
> tables. We'll see.
>
> Matt
>
>
--
View this message in context:
http://www.nabble.com/Matt-Krause---table-plugins-tf3373162.html#a9387551
Sent from the JQuery mailing list archive at Nabble.com.
_______________________________________________
jQuery mailing list
discuss@jquery.com
http://jquery.com/discuss/
