Search

want to add more columns for the name, etc.

by clicking on the columns. Do you not? Doesn't

And I have my columns datatable configuration: columns: [ null,

to. You should use columns.render as you have done in the other columns to create the content

the wildcard "_" when defining columns. So I change my

Take a look at this example, it has something very similar to your data structure. It'll show how to define those columns and data format. Cheers, Colin

The problem may be due to incompatibility between keyTable.js and FixedColumns , I use inline editor model and Tab between columns , i cant' work in select or select2 field

my date/time columns are sorting alphabetically. Did

Thank you very much , adding ajax to data table worked as mentioned below : $('#EmployeeTable').dataTable({ "ajax": { "url": "http://employeeproject/getAllEmployeeAjax/", "dataType": "json", "cache": false, "dataSrc": "" }, "order": [[1, "asc"]], columns: [ { 'data': 'EmployeeID' }, { 'data': 'EmployeeName' }, { 'data': 'Salary', render: $.fn.dataTable.render.number(',', '.', 0, '$ ') } ] }); Refresh Table :- $('#EmployeeTable').DataTable().ajax.reload();

At the moment you'd need to disable search and ordering on those columns - columns.searchable and columns.orderable. Allan