Search

saving and restoring the columns filters: https://datatables.net/forums/discussion/56943 How can

Currently I need to filter data by around 40~ nested values, so it will be not efficient to add & hide that amount of extra columns.

you have two id columns both will probably be

columns.data to define the columns and use columns.render to build '<a href="id='+data[i].id+'&modal"

This example shows how to export specified columns: https://datatables.net/extensions/buttons/examples/html5/columns.html This example shows how to export certain rows: https://datatables.net/extensions/buttons/examples/print/select.html If this doesn't help please provide more details of what you ware wanting to do. Kevin

dom: 'Bfrtip', ajax: '/api/FundOrgDeptGroup_Header', columns: [ { data: "FundOrgDeptGroup_Header.Department" }, { data: "vw_FundOrgFTE_DeptCounts.FTE_Sum"

By the time you're adding to columns[] you've already initialised the table. Kevin's final comment on this thread should help, since it's discussing this kind of thing. Colin

Found the answer in the end..Alter line 19 and add an extra { '' : '' } in columns. result.push([i, data.balances[i], data.balances[i] * spotRate ] );//gives data in 3 columns

api/deliverables', }, order: [[1, 'asc']], columns: [ { data: 'Deliverables.ClientProjectNumber' }, { data: 'Deliverables.CompanyProjectNumber'

Somethiing like: columns: [ {data: 'delivery-id'}, ............... {data: 'Actions', reponsivePriority: -1, render: function (data, type, row) { ==> here you can use "row.delivery_id" in your code as is suitable for you }, orderable: false }, .....