Search

about the number of columns selected in the table

method simply selects the columns that have been found

This method simply deselects the columns that have been found by the columns() selector method.

the panes for individual columns can be customised rather

will automatically determine which columns should be used for

SearchPanes will decide which columns to display a pane

set on for all columns by using the columns.searchPanes.initCollapsed

set this for all columns using the searchPanes.collapse option,

consider all of the columns when creating searchPanes. When

be set for individual columns. Normally SearchBuilder uses the

i was simply using: columns: ':not(.noVis, .colActions, .colControl):visible' but

Probably in a couple of months. I'm working on major updates for DataTables and the extensions at the moment, after which I will be looking at adding a new extension to allow manual resizing of columns. Allan

return column; }); } new DataTable('#projectTable', { columns: dtColumns, ordering: { indicators: false,

{ extend: 'excelHtml5', title: pg_name, exportOptions: { columns: ':not(.no-print):visible', orthogonal: null, format: { body: function (data, row, column, node) { var $node = $(node); if ($node.find("span.clsColsDateStr").length) { $node.find("span.clsColsDateStr").remove(); } var text = $node.text().trim(); var m = moment(text, ['DD-MMM-YYYY'], true); if (m.isValid()) { return m.format('YYYY-MM-DD'); } return text || ""; } } }, customize: function (xlsx) { } }

headers the first three columns need to be fixed

a fixed set of columns contain a match. I've

and suddenly all the columns lined up :smile: I

ajax call. Make few columns invisible , then go to

functionality. After hiding random columns: Navigating to the next

but only for specific columns. The other columns should