HTML-заголовок:
Код: Выделить всё
Код: Выделить всё
datat = $('#data-table').DataTable({
"processing": true,
"serverSide": true,
"ajax": {
"url": "",
"type": "POST",
"data": data
},
"drawCallback": function (settings) {
// Here the response
var response = settings.json;
console.log(response);
},
"searching": false,
"ordering": false,
"columns": JSON.parse(result.cols), //result.cols,
"stateSave": true,
"scrollY": '50vh',
"scrollCollapse": true,
"scrollX": true
});
Код: Выделить всё
{
"draw": 1,
"recordsTotal": 10426,
"recordsFiltered": 10426,
"data": [
{
"pkLocationLookupID": "1",
"fkLocationID": "1001",
"fkLookupID": "1000",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "2",
"fkLocationID": "1002",
"fkLookupID": "1000",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "3",
"fkLocationID": "1003",
"fkLookupID": "1000",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "4",
"fkLocationID": "1004",
"fkLookupID": "1000",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "5",
"fkLocationID": "1005",
"fkLookupID": "1000",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "6",
"fkLocationID": "1006",
"fkLookupID": "1000",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "7",
"fkLocationID": "1007",
"fkLookupID": "1000",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "8",
"fkLocationID": "1008",
"fkLookupID": "1002",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "9",
"fkLocationID": "1009",
"fkLookupID": "1003",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
},
{
"pkLocationLookupID": "10",
"fkLocationID": "1010",
"fkLookupID": "1003",
"fldOriginalCode": "",
"fldOriginalValue": "",
"fldSortOrder": ""
}
],
"columns": "[{ \"data\": \"pkLocationLookupID\" },{ \"data\": \"fkLocationID\" },{ \"data\": \"fkLookupID\" },{ \"data\": \"fldOriginalCode\" },{ \"data\": \"fldOriginalValue\" },{ \"data\": \"fldSortOrder\" }]"
}
Дайте мне знать, если есть какая-либо другая информация, которая может быть полезна для устранения неполадок. Любые идеи приветствуются, спасибо!
Подробнее здесь: https://stackoverflow.com/questions/798 ... er-updates