Search

can group by multiple columns. } } ] })

type, row); } return data; } } ], "columns": [ { "data": "TaskSchedulerLogUid", "visible": false

to show and hide columns depending on whether there

Resolved 1) defined the "columns": [ ] 2) in the buttons sections set exportOptions >> orthogonal: 'export'

Use a selector: select: { style: 'multi', selector: 'td:not(:first-child)' }, or something similar Here is another one. I have button and links in the rightmost two columns so they mustn't be selectable selector: 'td:not(:last-child, :nth-last-child(2))' // no row selection on last two columns

id", ajax: 'blank.jsp?_response=true&_action=loadDetails&id=' + $("#details").attr('data-footnote-id'), columns: [ { data: "label" }, { data: "value"

https://datatables.net/reference/option/pageLength and https://datatables.net/reference/option/lengthMenu like in here: var yourTable= $('#tblContract').DataTable({ dom: "Bfrltip", ajax: { url: '.....' }, pageLength: 0, lengthMenu: [0, 5, 10, 20, 50, 100, 200, 500], columns: [.....

Thanks for the example. I tried your example by reordering the columns and was not able to reproduce the problem. Can you provide steps to recreate the issue? Kevin

Yes, sorry to mention the Datatable. I am using Ajax to call the query and using array to output the SQL $rows. Using columns:[ ] option to output all the columns into the table.

example (no use of columns render) it uses a