Search

browsers. If using dt-init columnDefs` ensure that you have

of a table: $('#myTable').DataTable( { columnDefs: [ { targets: -1, className: 'dt-body-right'

for a columns or columnDefs column description: { data: 'start_date',

table body rows Use columnDefs.targets with only columns that

data: "users.phone" }, { data: "sites.name" } ], columnDefs:[{ searchPanes:{ show: true, }, targets:

we can use: $('#myTable').DataTable( { columnDefs: [ { targets: 0, render: DataTable.render.ellipsis()

available', position: 'bottom' } ] ); $('#myTable').DataTable( { columnDefs: [ { targets: 0, type: nameType

1, "asc" ]], pageLength: 25, columnDefs: [ { targets: -1, className: "priority"

See the columnDefs.targets docs for the options:

worked for me: $('#audits-datatable').DataTable({ columnDefs: [ { width: '70px', targets: [ 0,

Okay, I was able create dynamic columndefs by doing this

document).ready(()=>{ var maintable = $('#mainTable').DataTable( { columnDefs: [ { targets: 0, type: nameType

Sounds like the state was saved with the columns visible. You can use stateLoadParams to removed the columns from being loaded so the columnDefs are applied. Kevin

the below in the columnDefs renderer function var table_api

is right before the [ColumnDefs] section. ajax: { url: "/TimeSheet/LoadTimeSheetEntries",

and hide my types. columnDefs: [ { "visible": false, "targets": [6,

is what you want: "columnDefs": [ // { "bSearchable": true, "bVisible": false,

You would use either columns, or columnDefs, not both. If you need to define all columns (perhaps because you're using ajax objects), then put all the config into columns, Colin