I want to set data in more than one datatable with a special ajax, but Alert Error =DataTables warn
I want to set data in more than one datatable with a special ajax, but Alert Error =DataTables warn
var tableFragmentation = $('#tableFragmentation');
var containerGroupId = "";
var requestData;
$(document).ready(function () {
requestData = {
draw: 1,
start: 0,
length: 10,
search: {
value: "",
regex: false
},
order: [
{
column: 0,
dir: ""
}
]
};
$.ajax({
url: '/PostPcrUnits/FragmentationListDTJs',
type: 'POST',
dataType: 'json',
data: requestData,
success: function (response) {
//debugger;
var dataSet = response.data;
initFragmentationTable(dataSet);
}
});
});
// #region Datatables Pcr - Pcr Kabul Listesi
function initFragmentationTable(dataSet) {
tableFragmentation.DataTable({
processing: true,
serverSide: true,
ordering: true,
filter: true,
fixedColumns: { left: 1 }, //işlemler kolonu sabitleniyor.
scrollY: '400px',
scrollX: true,
autoWidth: true,
language: { url: '//cdn.datatables.net/plug-ins/1.10.22/i18n/Turkish.json' },
dom: "<'row'<'col-sm-12 col-md-6'B><'col-sm-12 col-md-6'f>>" +
"<'row'<'col-sm-12'tr>>" +
"<'row'<'col-sm-12 col-md-3'l><'col-sm-12 col-md-3'i><'col-sm-12 col-md-6'p>>",
buttons: [
{ extend: 'excel', text: 'Excel indir', },
{ extend: 'colvis', text: 'Goster/Gizle', },
],
data: dataSet,
columns: [
{
data: 'id',
render: function (data, type, row) {
var islem = "";
if (row.btnAddBarcodeFragmentation) {
islem += '<a data-id=' + data + ' id="btnSetBarcode" title="Onayla" class="btn btn-sm btn-icon item-edit"><i class="text-success ti ti-bookmarks"></i></a>';
}
return '<a data-id=' + data + ' id="btnGetPlate" title="Batch Icerik" class="btn btn-sm btn-icon item-edit"><i class="text-info ti ti-search"></i></a>' +
islem;
}
},
{ data: 'name' },
{
data: 'containerGroupType',
render: function (data, type) {
var result;
data === 11 ? result = "Batch CT" : data === 2 ? result = "Troubleshoot" : result = "Tanımsız";
return result;
}
},
{ data: 'batchSize' },
{ data: 'tagName' },
{ data: 'createdDate', render: DataTable.render.datetime('DD-MM-YYYY HH:mm') },
{ data: 'createdUserId' },
],
columnDefs: [
{ targets: 0, orderable: false, searchable: false, width: '100' },
]
});
};
// #endregion
Edit by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide
This discussion has been closed.
Answers
You have
serverSide: trueset but are usingdatainstead ofajax. That will cause errors. To utilize server side processing you will need to useajaxinstead ofdata.I see you are trying to emulate the the SSP parameters with the jQuery ajax() sent to the server. Why are you doing this instead of using the
ajaxoption?What errors do you get?
Kevin