Search

If you want to show different columns, and otherwise use different initialisation options, you would need to destroy the table (destroy()) and then create a new DataTable. Allan

Figured this out. I am only applying the search. I needed to add var monthRegex = ''; var monthResults for (i = 1; i <= 12; i++) { monthRegex = '^(['+i+']\/[1-9]{1,2}\/2014)$' monthResults = table.column(2).search( monthRegex, true, true ); monthResults = table .columns( [2], { search: 'applied', order:'current', page:'all' } ) .data(); }

Data", order: [[ 5, "asc" ]], columns: [ {"data": "ID"}, {"data": "UID"},

idArticolo'; // Array of database columns which should be read

Maybe are you looking for this: https://datatables.net/examples/api/row_details.html Show your 5/6 columns and on the click systems shows extra info

columns: [ { data: null, render: function ( data, type, row ) { // Combine the first and last names into a single table field return data.first_name+' '+data.last_name; } },

In case of different columns, I have to make second instance of editor and datatables? Which way I can switch between instances? is there any methods (table/editor visable?)

url: "includes/php/leave.php", type: "POST" }, columns: [ { "class": 'details-control', "orderable": false,

Can you link to a test page showing the issue please? mColumns is the option to use for defining which columns are exported. Allan

variables */ /* Array of database columns which should be read