3 functionality questions.

shredluc

1. I was wondering what would be the "correct" way to implement a conditional filter on one particular column. To be exact, i have a column with percentages and i want a select box to filter everything above: [ ">1%", ">5%", ">10%" ] or everything greater than 1%, 5% or 10%. I figure it has to do with $.fn.dataTableExt.afnFiltering and pushing my own filter there and then do a simple fnDraw()? Just want to verify that this would work.

2. Also in the near future i have to implement user hidable rows. These hidden rows must persist over ajax refreshes of table data and full page reloads with an option to unhide them all. How would one go about that so that it doesn't break any DataTables functionality?

3. Is there a way to specify logical "groups" of rows? I have data that fits the single row paradigm, it also can be logically grouped into types. For example [Apples, Berries, Grapes] Each group has multiple rows inside of that group. I want to be able to sort the whole group internally, so for example the groups themselves display alphabetically, but the quantity inside each group would be sorted from min to max separately. Kinda like this:
[code]
Apples
Red 1
Granny 5
Gala 9
Delicious 17
Berries
Blue 2
Red 8
Cran 14
Grapes
......
[/code]