Search

change the visibilty of columns (so if I draw())

but one of my columns in the table is

an attribute within the columns option, associated with a

the rest of the columns: $(document).ready(function() { $('#maintable').DataTable( { "aoColumns": [ null,

value":6} ] I have defined columns like so (I removed

Yep, I've tried both. There seems to be some sort of issue with searching the columns specifically. Using the standard out of the box search box works just fine.

Sadly, the only method I've found to do this requires two server calls (one for columns, one for data). Like this: $.get("/getColumns", function (cols) { $("#table").DataTable({columns: cols}); } ); Allan answers this here: http://www.datatables.net/forums/discussion/3519/getting-column-names-from-ajax-source

You would use the API methods that @jr42.gordon linked to. There are examples in those reference pages. Primarily you use the column() selector method to select the columns you want to target. Allan

to sort on multiple columns at once the generated

SELECT SQL_CALC_FOUND_ROWS '', '', '' That doesn't look good. It appears to be caused by the fact that you don't have a db field in the columns arrays like in the examples. Fixing that should address the issue. Allan