Search

consistent width to the columns in the table in

have not specified more columns than there are in the HTML If using columns.render or columns.data ensure that

that the number of columns in the table header

be: $('#example').DataTable( { ajax: "../php/staff.php", columns: [ { data: "first_name" }, { data: "last_name"

will automatically scan a column's data and determine if

be used for multiple columns (or none if a

Using columns.render is the most common

the columns.data and / or columns.render options as objects. Consider

Winters", "Director", "$5,300", "Edinburgh" ) ], columns: [ { data: 'name' }, { data: 'salary'

headers: Colspan with hidden columns demo 1.8 introduces super

hi... In fact you fucntion set all columns not visible else qCol perhaps logical toggle function toggleColumns(qCol) { contentTable.column(qCol).visible( ! contentTable.column(qCol).visible()); contentTable.draw(); }

still moving around the columns. Are you saying that

If you want to be able to define the columns by the Ajax loaded data, you need to get the column information first and then load the DataTable. This FAQ covers that. Allan

I guess you could fix all of the first five columns, and then call columns().visible() to hide the columns on a scroll. This SO thread discusses detecting scrolls, so could be used as a starting point. Colin

matter what order the columns are in the plugin

document).ready(function() { $('#jobs').DataTable( { "dom" : "<'row'<'small-6 columns dash-toolbar'><'small-6 columns'f>r>"+ "t"+ "<'row'<'small-6

way as well: exportOptions: { columns: function(column, data, node) { if

I have updated the test case as: I had a mistake in the columns indices Now filters are visible by changing the following: .appendTo( $("thead tr:eq(1) td").eq(column.index()).empty() ) to .appendTo( $('thead tr:eq(1) th:eq(' + column.index() + ')').empty() ) Thanks again

Hi! In column definition, add a className: "columns": [ { "data": "mycolumn, "className": 'fixed_width', }, Use CSS to add a width of your choice to one or many columns: table.dataTable td.fixed_width { width:10px; } /Anders

how to export certain columns. If you still need