Datatables flitering and search button

FRS4002

How can I filter only specific columns like for example column 3 and 4 when searching?

colin

You can disable searching in specific columns with columns.searchable - see example here: http://live.datatables.net/bilofufi/1/edit

Colin

FRS4002

@colin Thanks! It worked! But what if I need also to do
columnDefs: [{
targets: 3,
render: function (data, type, row){
if (type === 'filter'){
return data.replace(/e/g, 'i');
}
return data.replace();
}
}
],
I need to merge both, how?

kthorngren

Just add searchable: false, like this:

columnDefs: [{
  targets: 3,
  searchable: false,
  render: function (data, type, row){
  if (type === 'filter'){
    return data.replace(/e/g, 'i');
  }
  return data.replace();
  }
}
],

To properly use Markdown place the three back ticks on their own line. One set at the beginning of the code snippet and another at the end. You don't need them on each line. Like this screenshot:

The js is for Javascript formatting. Read more about it here.

Kevin

FRS4002

@kthorngren Nope. That's not what I need. I need target 3 for replace and targets 0,1,4 for searchable false. How can I do that?

kthorngren

Add another object to columnDefs like this:

columnDefs: [{
  targets: 3,
  render: function (data, type, row){
  if (type === 'filter'){
    return data.replace(/e/g, 'i');
  }
  return data.replace();
  }
},
{
  targets: [0, 1, 4],
  searchable: false
}
],

Kevin

FRS4002

@kthorngren Perfect! It worked! Thanks!