Generating TFOOT

peterkronenberg

I am using Datatables to generate the THEAD row using aoColumns. How can I get the TFOOT section to be automatically generated?

allan

DataTables doesn't automatically generate a TFOOT. Perhaps this would be a nice option actually, when generated a header to add the footer as well. However, the easy way around it is just to use normal jQuery or DOM methods to create and insert the node as needed. $('#example').append('...'); for example.

Allan

peterkronenberg

Using normal Jquery or DOM doesn't quite work if there are columns hidden with ColVis. Is there a way to retrieve all the columns, hidden or not?

allan

You need to create the element before initialising DataTables if using hidden columns. It's possible to add it after initialisation, but much harder.

Allan

peterkronenberg

The problem is I am letting DataTables create everything. The only solution I can see is to hide the columns after initialization, using fnSetColumnVis instead of bVisible.

peterkronenberg

Hmm, actually, this still doesn't seem to work since ColVis does not know about the tfoot and is therefore not properly adjusting it when columns are hidden.