When using Fixed Column in 1.10, the Column Filter for the Fixed Column Does Not Filter

latcron

My main user is in a panic; with the previous version of DataTables, the Fixed Column scroll wasn't rendering properly (especially when she zoomed the page for conferences). So I'm making a quick leap to 1.10 because the demo seemed to zoom/scroll the Fixed Column much more nicely. However, the trade-off seems to be that the Column Filter for that Fixed Column no longer filters the rows (my main user loves her column filtering, can't live without it because we have tables with up to 20-odd columns and otherwise get too many false positives).

I used DataTables live to try to replicate the problem, but while I put in my hodgepodge of old/new js for DataTables, the left column isn't fixed, so it's not quite replicating the problem, save that the column filtering isn't working at all.

Maybe the syntax/methodology for implementing the column filtering has changed?

http://live.datatables.net/yugusage/1/edit?css,js,output

Hopefully the answer's right under my nose because I've got to get some kind of fix before the next conference and I don't want my solution to be un-fixing the left column!

algee

i had the same problem.

problem is, the fixed columns you see are cloned, onto a second table and used as an overlay,
just as stated in the reference for this extension: http://datatables.net/extensions/fixedcolumns/

install firebug and have a look at the final html source. depending on your colum setup
you'd want to look for a div with the class 'DTFC_LeftWrapper', and among that 'DTFC_LeftFootWrapper'

the solution should be, to apply the 'keyup change' eventhandler also on that cloned footer table.

i will look into that later, and provide any solutions i find, unless anyone else is quicker ;)

but i also encountered another wierd problem with fixedcolumns:
http://datatables.net/forums/discussion/34211/fixedcolumns-reloading-table-with-dynamic-colums#latest
which renders the extension unusable for me, so i didn't really care about the filter problem so far :/

latcron

Thanks, I will try what you recommend.

Probably my real problem is that I'm (cringe) using FixedColumn with FixedHeader, which is explicitly not compatible, but which mostly worked under the last version I was using (so close to just what I need!). I'm also going to try pagination instead of scrolling, though my main user prefers the scrolling behavior. Hopefully working column filters will make up for pagination if I take that option.

latcron

Pagination didn't help. I had to capture the text on the visible input box beneath the fixed column and then pass that to the "hidden" input box for the fixed column. That passing of the value triggers (as far as I can tell) the regular column filtering and the first, fixed column filter now works as expected.

I'm still having intermittent, hard-to-reproduce row alignment issues between the fixed column and the rest of the DataTable, but can't address that until I can make the problem consistently reproducible.