Search

cells.join('') + '</row>'; }; //Define the columns if (config.header) { xml += addRow(data.header);

configured to filter specific columns only, see showcase page

i think this is how we write it :smile: buttons: [ { extend: 'copy', exportOptions: {columns: ':visible'} }, { extend: 'print', exportOptions: {columns: ':visible'} }, { extend: 'csv', exportOptions: {columns: ':visible'} }, { extend: 'excel', exportOptions: {columns: ':visible'} }, { extend: 'pdf', exportOptions: {columns: ':visible'} }, 'colvis' ]

PHP code - server side $columns = array( // 0 => 'Number',

I figured out above option 2 from the Hidden Columns example. The table is initialized below with the necessary columnDefs: var t = $('#example').DataTable( { "order": [[ 0, "desc" ]], "columnDefs": [ { "targets": [ 0 ], "visible": false, "searchable": false }, ] });

There is an example showing how to use Editor with only specific columns available here. Allan

This example shows how you can do a multi-column layout in the Editor modal. That example is for two columns, but it could readily be used for four columns by setting the width to 25%. Allan

dom: "Bfrtip", ajax: "assignments.php", columns: [ { data: "jobs.job_number" }, { data: "jobs.job_name"

Delete' } ); } ); $('#example').DataTable( { ajax: "php/staff.php", columns: [ { data: null, render: function

using Responsive to have columns automatically hide. Allan