How to define Columndefs after DataTables initialization

rohitkrishna12

Hi All,
As a newbie to Datatables, im stuck to get the sorting right in datatables.

Currently I'm using DataTables in each page initializing them individually like this.

var table = $('#' + '<%= gvReports.ClientID %>').DataTable({
"responsive": true,
"bAutoWidth": true,
"oLanguage": {
"sSearch": "Search Table: ",
"sSearchPlaceholder": "Search records",
"sEmptyTable": "No data available to display"
},
"columnDefs": [
{
"targets": [0],
type: 'natural-nohtml'
}
],
"sScrollY": "55vh",
"scrollCollapse": false,
"pagingType": "full_numbers",
"lengthMenu": [[25, 50, 100, 150, 200], [25, 50, 100, 150, 200]]
});

When i tried to create a generic JQeury method like below to use in multiple places the type attribute in columnDef for column 0 with type as natural is not working at all. The below method is in file called Common.js which was included into the page. and in doc.ready im calling this function to initialize my datatable.

function CreateBasicQueueTable(gridId) {
$('#' + gridId).DataTable({
fixEmptyTable: true,
conditionalLength: true,
conditionalPaging: true,
"responsive": true,
"bAutoWidth": true,
"oLanguage": {
"sSearch": "Search Table: ",
"sSearchPlaceholder": "Search records",
"sEmptyTable": "No data available to display"
},
"columnDefs": [
{
"targets": [0],
type: 'natural-nothml'
}
],
"sScrollY": "55vh",
"scrollCollapse": false,
"pagingType": "full_numbers",
"lengthMenu": [[25, 50, 100, 150, 200], [25, 50, 100, 150, 200]]
});
}

"columnDefs": [
{
"targets": [0],
type: 'natural-nohtml'
}
],

Im using NatualSort plugin to sort the data as the column '0' contains alphanumeric data.

Is there a way i can set the columnDefs dynamically? or to set the ColumnDef Type for Column(0) after I initialize the table? Something Like

table.column("0:visible").Type('natural-nohtml');

Any help is appreciated? I want to know if I'm thinking in right way?