A basic DataTable needs at least this:
<script>
$(document).ready(function() {
$('#example').DataTable( {
"ajax":{
"url":"URL HERE",
"cache": true,
"dataSrc": "People",},
"searching":false,
"paging":false,
"aaSorting": [[1,'desc'], [2,'asc']],
"responsive":true,
"bAutoWidth":false,
"orderable": true,
columns: [
{ data: "DATA","width": "20%"},
{ data: "Name" },
{ data: "Address" },
{ data: "DATA", "orderable": false },
{ data: "DATA" },
{ data: "DATA" },
{ data: "DATA" },
{ data: "DATA" },
{ data: "DATA" },
{data: "DATA"}
]
});});
</script>
You have no
DataSource
And regarding that commented out section, You don't need to use mData there because aTargets already resolved that.
Take note of what i did with
"orderable"
Updated to give op some clarity:
<script>
$(document).ready(function() {
$('#example').DataTable( {
"ajax":{
"url":"URL HERE",
"cache": true,
"dataSrc": "DATASOURCE",},
"searching":false,
"paging":false,
"aaSorting": [[1,'desc'], [2,'asc']],
"responsive":true,
"bAutoWidth":false,
"orderable": true,
"columns": [
{ "data": "Estimate_ID" },
{ "data": "ESTIMATE_DESCRIPTION", "orderable": false },
{ "data": "FLIGHT_START_DATE" },
{ "data": "FLIGHT_END_DATE" },
{ "data": "ESTIMATE_COMMENTS", "orderable": false },
{ "data": "AGENCY_ID"},
{ "data": "UPD_DATE"},
{ "data": "PROC_DATE", "orderable": false },
{ "data": "ESTIMATE_CD"},
{ "data": "SALES_ASSISTANT"},
{ "data": "AE_STAFF_ID", "orderable": false },
{ "data": "order_type_id"},
{ "data": "cost_type"}
]
});});
</script>