Show entries dropdown disappear when using export tools
You just lack the l
flag in dom
. l
for "length changing input control".
dom: 'lBfrtip'
will make the dropdown to reappear.
updated fiddle -> http://jsfiddle.net/p33x5L3t/1/dom
documentation -> https://datatables.net/reference/option/dom
I know it is too long, but if some one still facing this issue, then please do the following, it is an alternate answer.
Add 'pageLength' inside buttons as follows:
$('#example').DataTable( {
dom: 'Bfrtip',
buttons: [
'pageLength','copy', 'csv', 'excel', 'print'
]
} );
This works for me:
$(document).ready(function(){
dataTable = $('#myDataTable').DataTable({
"processing":true,
"serverSide":true,
dom:'lBfrtip',
buttons: ['excel', 'csv', 'pdf', 'copy'],
"lengthMenu": [50,100,500,1000,2000,5000,10000,50000,100000],
"order":[],
"sScrollX": "100%",
"scrollCollapse": true,
"ajax":{
url:"FetchAllAjax.php",
type:"POST"
}
});
});