Datatable server side export only capture 1st page
0
Below is my script. Im using the custom filter datetime range. The first load it will load the empty data because i wanted to avoid load the data when open this page until we filter it only it will appear the filtered data. But the export things seem only took the first pages of the datatable. For example 400 rows of data load after filter, and when export as excel, it will took 10 rows of the data instead of 400 rows.
$(document).ready(function() {
$('#datetimepicker').datetimepicker({
format: 'yyyy-mm-dd HH:mm:ss'
});
$('#datetimepicker1').datetimepicker({
format: 'yyyy-mm-dd HH:mm:ss'
});
fetch_data('no');
var buttonCommon =
{
exportOptions:
{
modifier: {
page: 'all'
},
format: {
body: function ( data, row, column, node )
{
return column === 10 ?
data.replace( /[$,]/g, '' ) :
data;
}
}
}
};
function fetch_data(is_date_search, datetimepicker='', datetimepicker1='')
{
var dataTable = $('#demo-custom-toolbar').DataTable( {
"responsive": true,
"processing": true,
"serverSide": true,
"ajax":{
url :"read.php", // json datasource
type: "post",
data:{
is_date_search:is_date_search, datetimepicker:datetimepicker, datetimepicker1:datetimepicker1
},
// method , by default get
error: function()
{ // error handling
$(".employee-grid-error").html("");
$("#demo-custom-toolbar").append('<tbody class="employee-grid-error"><tr><th colspan="3">No data found in the server</th></tr></tbody>');
$("#employee-grid_processing").css("display","none");
}
},
rowReorder: {
selector: 'td:nth-child(2)'
},
responsive: true,
dom: 'lBfrtip',
buttons: [
$.extend( true, {}, buttonCommon, {
extend: 'copyHtml5'
} ),
$.extend( true, {}, buttonCommon, {
extend: 'excelHtml5'
} ),
$.extend( true, {}, buttonCommon, {
extend: 'pdfHtml5'
} )
]
} );
}
//$("#employee-grid_filter").css("display","none"); // hiding global search box
$('#search').click(function(){
var start_date = $('.datetimepicker').val();
var end_date = $('.datetimepicker1').val();
if(start_date !='' && end_date !='')
{
$('#demo-custom-toolbar').DataTable().destroy();
fetch_data('yes', start_date, end_date);
}
else
{
alert("Both Date is Required");
}
});
} );
i tried to put this below code also it does not works as well.
exportOptions: {
modifier: {
page: 'current'
}
},
php jquery datatable
asked Nov 21 '18 at 1:22
parkwayparkway
16310
add a comment |
0
Below is my script. Im using the custom filter datetime range. The first load it will load the empty data because i wanted to avoid load the data when open this page until we filter it only it will appear the filtered data. But the export things seem only took the first pages of the datatable. For example 400 rows of data load after filter, and when export as excel, it will took 10 rows of the data instead of 400 rows.
$(document).ready(function() {
$('#datetimepicker').datetimepicker({
format: 'yyyy-mm-dd HH:mm:ss'
});
$('#datetimepicker1').datetimepicker({
format: 'yyyy-mm-dd HH:mm:ss'
});
fetch_data('no');
var buttonCommon =
{
exportOptions:
{
modifier: {
page: 'all'
},
format: {
body: function ( data, row, column, node )
{
return column === 10 ?
data.replace( /[$,]/g, '' ) :
data;
}
}
}
};
function fetch_data(is_date_search, datetimepicker='', datetimepicker1='')
{
var dataTable = $('#demo-custom-toolbar').DataTable( {
"responsive": true,
"processing": true,
"serverSide": true,
"ajax":{
url :"read.php", // json datasource
type: "post",
data:{
is_date_search:is_date_search, datetimepicker:datetimepicker, datetimepicker1:datetimepicker1
},
// method , by default get
error: function()
{ // error handling
$(".employee-grid-error").html("");
$("#demo-custom-toolbar").append('<tbody class="employee-grid-error"><tr><th colspan="3">No data found in the server</th></tr></tbody>');
$("#employee-grid_processing").css("display","none");
}
},
rowReorder: {
selector: 'td:nth-child(2)'
},
responsive: true,
dom: 'lBfrtip',
buttons: [
$.extend( true, {}, buttonCommon, {
extend: 'copyHtml5'
} ),
$.extend( true, {}, buttonCommon, {
extend: 'excelHtml5'
} ),
$.extend( true, {}, buttonCommon, {
extend: 'pdfHtml5'
} )
]
} );
}
//$("#employee-grid_filter").css("display","none"); // hiding global search box
$('#search').click(function(){
var start_date = $('.datetimepicker').val();
var end_date = $('.datetimepicker1').val();
if(start_date !='' && end_date !='')
{
$('#demo-custom-toolbar').DataTable().destroy();
fetch_data('yes', start_date, end_date);
}
else
{
alert("Both Date is Required");
}
});
} );
i tried to put this below code also it does not works as well.
exportOptions: {
modifier: {
page: 'current'
}
},
php jquery datatable
asked Nov 21 '18 at 1:22
parkwayparkway
16310
add a comment |
0
0
0
Below is my script. Im using the custom filter datetime range. The first load it will load the empty data because i wanted to avoid load the data when open this page until we filter it only it will appear the filtered data. But the export things seem only took the first pages of the datatable. For example 400 rows of data load after filter, and when export as excel, it will took 10 rows of the data instead of 400 rows.
$(document).ready(function() {
$('#datetimepicker').datetimepicker({
format: 'yyyy-mm-dd HH:mm:ss'
});
$('#datetimepicker1').datetimepicker({
format: 'yyyy-mm-dd HH:mm:ss'
});
fetch_data('no');
var buttonCommon =
{
exportOptions:
{
modifier: {
page: 'all'
},
format: {
body: function ( data, row, column, node )
{
return column === 10 ?
data.replace( /[$,]/g, '' ) :
data;
}
}
}
};
function fetch_data(is_date_search, datetimepicker='', datetimepicker1='')
{
var dataTable = $('#demo-custom-toolbar').DataTable( {
"responsive": true,
"processing": true,
"serverSide": true,
"ajax":{
url :"read.php", // json datasource
type: "post",
data:{
is_date_search:is_date_search, datetimepicker:datetimepicker, datetimepicker1:datetimepicker1
},
// method , by default get
error: function()
{ // error handling
$(".employee-grid-error").html("");
$("#demo-custom-toolbar").append('<tbody class="employee-grid-error"><tr><th colspan="3">No data found in the server</th></tr></tbody>');
$("#employee-grid_processing").css("display","none");
}
},
rowReorder: {
selector: 'td:nth-child(2)'
},
responsive: true,
dom: 'lBfrtip',
buttons: [
$.extend( true, {}, buttonCommon, {
extend: 'copyHtml5'
} ),
$.extend( true, {}, buttonCommon, {
extend: 'excelHtml5'
} ),
$.extend( true, {}, buttonCommon, {
extend: 'pdfHtml5'
} )
]
} );
}
//$("#employee-grid_filter").css("display","none"); // hiding global search box
$('#search').click(function(){
var start_date = $('.datetimepicker').val();
var end_date = $('.datetimepicker1').val();
if(start_date !='' && end_date !='')
{
$('#demo-custom-toolbar').DataTable().destroy();
fetch_data('yes', start_date, end_date);
}
else
{
alert("Both Date is Required");
}
});
} );
i tried to put this below code also it does not works as well.
exportOptions: {
modifier: {
page: 'current'
}
},
php jquery datatable
asked Nov 21 '18 at 1:22
parkwayparkway
16310
Below is my script. Im using the custom filter datetime range. The first load it will load the empty data because i wanted to avoid load the data when open this page until we filter it only it will appear the filtered data. But the export things seem only took the first pages of the datatable. For example 400 rows of data load after filter, and when export as excel, it will took 10 rows of the data instead of 400 rows.
$(document).ready(function() {
$('#datetimepicker').datetimepicker({
format: 'yyyy-mm-dd HH:mm:ss'
});
$('#datetimepicker1').datetimepicker({
format: 'yyyy-mm-dd HH:mm:ss'
});
fetch_data('no');
var buttonCommon =
{
exportOptions:
{
modifier: {
page: 'all'
},
format: {
body: function ( data, row, column, node )
{
return column === 10 ?
data.replace( /[$,]/g, '' ) :
data;
}
}
}
};
function fetch_data(is_date_search, datetimepicker='', datetimepicker1='')
{
var dataTable = $('#demo-custom-toolbar').DataTable( {
"responsive": true,
"processing": true,
"serverSide": true,
"ajax":{
url :"read.php", // json datasource
type: "post",
data:{
is_date_search:is_date_search, datetimepicker:datetimepicker, datetimepicker1:datetimepicker1
},
// method , by default get
error: function()
{ // error handling
$(".employee-grid-error").html("");
$("#demo-custom-toolbar").append('<tbody class="employee-grid-error"><tr><th colspan="3">No data found in the server</th></tr></tbody>');
$("#employee-grid_processing").css("display","none");
}
},
rowReorder: {
selector: 'td:nth-child(2)'
},
responsive: true,
dom: 'lBfrtip',
buttons: [
$.extend( true, {}, buttonCommon, {
extend: 'copyHtml5'
} ),
$.extend( true, {}, buttonCommon, {
extend: 'excelHtml5'
} ),
$.extend( true, {}, buttonCommon, {
extend: 'pdfHtml5'
} )
]
} );
}
//$("#employee-grid_filter").css("display","none"); // hiding global search box
$('#search').click(function(){
var start_date = $('.datetimepicker').val();
var end_date = $('.datetimepicker1').val();
if(start_date !='' && end_date !='')
{
$('#demo-custom-toolbar').DataTable().destroy();
fetch_data('yes', start_date, end_date);
}
else
{
alert("Both Date is Required");
}
});
} );
i tried to put this below code also it does not works as well.
exportOptions: {
modifier: {
page: 'current'
}
},
php jquery datatable
php jquery datatable
asked Nov 21 '18 at 1:22
parkwayparkway
16310
asked Nov 21 '18 at 1:22
parkwayparkway
16310
asked Nov 21 '18 at 1:22
parkwayparkway
16310
asked Nov 21 '18 at 1:22
parkwayparkway
16310
asked Nov 21 '18 at 1:22
parkwayparkway
16310
16310
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53404002%2fdatatable-server-side-export-only-capture-1st-page%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53404002%2fdatatable-server-side-export-only-capture-1st-page%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
