Search not working when first column is a checkbox
Search not working when first column is a checkbox
Hi,
I am having an issue when my first column is a checkbox, and data = null, search stops working and throwing an error (image attached)
It needs to associate a value in the data for that particular column to make it works, but I do not want to display any information in that column just the checkbox . I have done this in previous versions and it worked perfect. at the moment I am using Editor Data Tables v1.6.1.0
I tried a trick using CSS to make text in that column transparent, but the problem is the check became also transparent.
How could I solve this?
Thanks in advance for any help provided,
Wilson
Code
var table = $('#tblList').DataTable({
"idSrc": "ParcelNumber",
"searching": true,
"bPaginate": true,
"bInfo": true,
//"bAutoWidth": true,
"processing": true,
"serverSide": true,
"iDisplayLength": 20,
"pagingType": "full_numbers",
"aLengthMenu": [[10, 20, 50, 100], [10, 20, 50, 100]],
"ajax": {
"url": "/Locations/DTIndex",
"type": "POST"
},
columns: [
{
data: null,//"ParcelNumber",
defaultContent: '',
className: 'select-checkbox',
orderable: false,
visible: false
},
{ data: "ParcelNumber" },
{ data: "StreetDetailsToSearch" },
{ data: "Suburb" },
{
data: "PropertyArea", className: "tdFixedWidth120 alignRight",
render: function (data, type, row) {
return numberFormat(data);
}
}
],
order: [1, 'asc'],
keys: {
columns: ':not(:first-child)',
keys: [9]
},
select: {
style: 'os',
selector: 'td:first-child'
},
rowCallback: function (row, data) {
$(row).addClass('trLink'); //When the row has a link
}
});
Answers
Hi,
I solved the issue updating to version 1.6.3
Wilson
Thanks for the update - good to hear you have it working now. It would also be worth adding
columns.searchable
and setting it to befalse
for your first column.Allan