Search

I would suggest simply settings ajax.dataSrc to be data.items. Then you can use data: 'price' etc in the columns array (note that there is no item option for the columns as you have above - see the columns.data reference documentation). Allan

need to define the columns in DataTables - there is

success') { $('#sample').DataTable({ data: jsondata.responseText, columns: [ { title: "ImportItemMasterId" }, { title: "ItemName"

buttons: [ { extend: 'print', exportOptions: { columns: ':visible' }, orientation: 'portrait', defaultStyle:

through each of my columns and dynamically create a

want to hide multiple columns, you would want the

@allan, here is an example I threw together: https://codepen.io/anon/pen/pgrgbM I want the export versions of columns "Type A" & "Type B" to have new lines. If you look at the JSON source you will see the new lines.

there is no hidden columns) // then take no action

Hi Allen, Thanks a lot for pointing out this example. Turns out one specific line of code in the example is crucial the wanted behaviour. Thanks again! keys: { columns: ':not(:first-child)', editor: editor //THIS LINE FIXED THE PROBLEM },

dom: "Brt", ajax: "...upload.php", columns: [ { data: "document", render: function