How to implement Button Click Open Search Builder and Search Column hide custom in my code
How to implement Button Click Open Search Builder and Search Column hide custom in my code
jankumar1980
Posts: 6Questions: 2Answers: 0
$(document).ready(function () {
var table = $('#Analysis').DataTable({
lengthChange: true,
dom: 'lBfrtip',
"colvis": [
{ "searchable": false, "targets": 1 }
],
buttons: [
'copy',
'excel',
'csv',
{
text: 'PDF',
extend: 'pdfHtml5',
action: function (e, dt, node, config) {
PrintDiv();
}
},
],
searchBuilder: {
conditions: {
num: {
'MultipleOf': {
conditionName: 'Multiple Of',
init: function (that, fn, preDefined = null) {
var el = $('<input/>').on('input', function () { fn(that, this) });
if (preDefined !== null) {
$(el).val(preDefined[0]);
}
return el;
},
inputValue: function (el) {
return $(el[0]).val();
},
isInputValid: function (el, that) {
return $(el[0]).val().length !== 0;
},
search: function (value, comparison) {
return value % comparison === 0;
}
}
}
}
}
});
var buttonContainer = table.buttons().container();
var searchBuilderContainer = table.searchBuilder.container();
buttonContainer.insertBefore(table.table().container());
searchBuilderContainer.insertBefore(table.table().container());
});
Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
Answers
I'm not sure what you mean. Do you mean putting SearchBuilder into a button? See this example.
For column visibility see this example (
colvisneeds to be in your buttons array).Allan
Already i am try to implement. but not success. please help improve my code
i need Search Builder button including buttons: [
'copy',
'excel',
'csv',
{
text: 'PDF',
extend: 'pdfHtml5',
action: function (e, dt, node, config) {
PrintDiv();
}
},
],