Exporting full data using TableTools by requerying the mySql Database

meeramarygeorge

I need to export 2 types of data, one with only selected columns from the datatable (which works fine). Another by re-querying the table to get all the data. Is there a way to implement this using TableTools.
How can I return the data if I use the sAjaxUrl to query using PHP.

aButtons: [
{
sExtends: "collection",
sButtonText: "Export",
aButtons: [
{
sButtonText: "Excel (Only Selected)",
sExtends: "xls",
bSelectedOnly: true,
sFileName: "Requests <?=date('m-d-Y')?>.xls"
},
{
sButtonText: "Excel (All Data)",
sExtends: "xls",
bSelectedOnly: false,
sFileName: "All Requests <?=date('m-d-Y')?>.xls"
}
] } ],