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"

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

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

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,