Search

Nice one - thanks for flagging that up. I'll fix it when I get into the office on Monday. Allan

Hi there I am trying to search 2 values in a column through the below way.. dataTable.columns(7).search("Completed|Pending",true).draw(); Also how can i search a column for all values except a particular to get displayed? All my search values are coming from my url parameter - So i dont know how to pass them to the table generally. But this does not seem to work. Any alternative?

I am trying to archive fixed column width https://datatables.net/reference/option/columns.width with responsive datatables $('#example').dataTable( { "columnDefs": [ { "width": "20%", "targets": 0 } ] } ); but if the column text is grater than specified with like ( "width": "20%") it is auto resizing the column width. how can i restrict it fit within column width and trim excess using ellipsis ?

It would be nice if you can use other column-selectors like name for ColVis exclude

Use x for Unix mS (Moment docs for formatting). For example you could use: render: DataTable.render.datetime('x', 'DD/MM/YYYY') for such a column (columns.render). That form will read the given format and then display it in whatever format you give. Allan

just the year. Use columns.render in that column to.

ajax structure, or missing columns.render functions when needed). So

names. You can use columns.render to create your own

in a specific column: column.search('^$', { regex: true, exact: false,

Copy', exportOptions:{columns:':visible'}}, {extend:'excel',text:' Excel',exportOptions:{columns:':visible'}}, 'columnsToggle' ], order:[[1,'asc']], paging:false,bInfo:true,scrollX:true, initComplete:function(){ var