Search

While the basic functionality was great, we looked into advanced features like stateSave and only allowing some columns to be sortable. Here is the end result...

from 'datatables.net-bs5'; DataTable.use(DataTablesCore); const columns = [ { data: 'name' }, { data: 'position'

be applied to all columns which have searchable as

for data across all columns. The built in search

DataTable.use(DT); function App() { const columns = [ { data: 'name' }, { data: 'position'

to dynamically select rows, columns and cells in the

Line 3 - Select all columns in the table with

ajax: ... } ); // or! $('#myTable').DataTable( { ajax: ..., columns: [ { data: 0 }, { data: 1

the visibility of the columns will be saved.

the visibility of the columns will be saved.

work. You have 5 columns defined. Do you have

Not a bug. DT requires the same number of columns in each row. Are you setting default content values in your DT columns initialisation?

and 'columndefs' for defining columns. How may I use

buttons should export all columns: 'copy', 'csv', 'excel', 'pdf'

Try removing columnDefs and just apply the config in columns. Something like this: columns: [ { "data": null, defaultContent: "", "targets": 'selectionCol', orderable: false, className: 'select-checkbox' }, { "data": "FIO" }, { "data": "FullPostNameRU" }, { "data": "depnameRU" } ], Kevin

Yep, the header class won't trickle down onto the column's cells. As silkspin said, columns.className is the way to go, Colin

initComplete callback. table.columns().visible(false); Using columns() without a column-selector will result in selecting

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