Search

number. $('myTable').DataTable( { searchPane: true, columnDefs:[ { searchPanes:{ options:[ { label: 'Over

in the columns or columnDefs arrays of the DataTables

the column property options, columnDefs requires a targets property

to be columns and columnDefs, the columnDefs.targets option can only be

This option is simply an alias of the columnDefs.targets option and is provided to allow for clarity when matching against a single column only.

an object of the columnDefs array - this will apply

var table = new DataTable('#myTable', { columnDefs: [ { visible: false, targets: 1

combined object resulting from columnDefs and columns initialisation options,

automatic number formatting: $('#example').DataTable({ columnDefs: [ { target: 5, render: DataTable.render.number(),

length select list. aTargets columnDefs.targets Specify the columns that

You defined columnDefs twice. The second is overwriting the first. Please combine them into one option and see if it works. The columnDefs.targets docs state to use the string "_all" to assign to all columns. Kevin

Thank you! That helped me work out a solution that seems to be working: var customColumnDefs=$.extend(true, {}, $.fn.dataTable.defaults).columnDefs; customColumnDefs.push( { width: "175px", targets: [ 4,5 ] } ); $('#data-list').DataTable({ columnDefs: customColumnDefs, order: [ [5, 'desc'], [1, 'asc'] ], drawCallback: toggleDataTableControls } });

correction, without the definition of columnDefs the data is not loaded into the table

I cannot seem to figure out what it is I'm doing wrong here. always show error in 'columnDefs'

Can/Should https://datatables.net/reference/option/searching and columnDefs be used together, e.g? "searching": false, "columnDefs": [{ "searchable": true, "targets": 1,2,4,6 }],

TS: columnDefs: [ { .. searchPanes} <- not exists

do the same with columnDefs -- either to setup initial

The columnDefs is an array of

the sorting via define: "columnDefs": [ { "type": "date", "targets": [4]

to the end with columnDefs.targets set to -1. You