How to exclude column in column filtering

NoBullMan

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:
I am using column filtering using this example.

The first column in my table is a "select" column, with checkoxes. I am trying to exclude it from filtering.
I can stop the input textbox from displaying by checking if column index is zero or not:
(although not sure if this is the right way of doing it or not.)

initComplete: function () {
    var api = this.api();
    var cursorPosition;
    // For each column
    api
        .columns()
        .eq(0)
        .each(function (colIdx) {
            if (colIdx != 0) {
                ...
            }
        });

However, I am not sure how to prevent the first column to be cloned in:

$('#MyTable thead tr')
    .clone(true)
    .addClass('filters')
    .appendTo('#MyTable thead');

kthorngren

The columns() API as many options for selecting the columns. See the column-selector. You might be able to use :not(:first-child) to skip the first column, for example:

    api
        .columns( ":not(:first-child)" )
        .eq(0)

Kevin

NoBullMan

Thank you Kevin. It is the cloning part I am struggling with.

kthorngren

Ah. So you want the first column to span both header rows? After cloning you will need to remove the th in the second row and set the rowspan attribute to 2 for the first th in the first row. Like this:
http://live.datatables.net/muqijeya/1/edit

Kevin

NoBullMan

Thank you; that did it. I had to revert back the initial change from

api
     .columns( ":not(:first-child)" )
     .eq(0)

to

api
    .columns( )
    .eq(0)

NoBullMan

Weirdest thing happens now!
When I type something in column X's input box, it searches column X-1.
I think first-child of the columns has moved one to the right.

NoBullMan

Had to also change:

api
    .column(colIdx)
    .search(....

to

api
    .column(colIdx + 1)
    .search(....