FixedColumn not working with server side processing in dataTables..??
FixedColumn not working with server side processing in dataTables..??
kavittp
Posts: 12Questions: 0Answers: 0
Dear Allan..,
I am facing some critical problem in dataTables.
Right now i am using dataTable with serverside processing.
Actually my table contains large no. of columns...so i just want to implement FixedColumn with server side processing.
So according to dataTable's documentation i used FixedColumn and initialized it in dataTable.
As a result..when dataTable implements..it doesn't follow FixedColumn property.. and dataTables columns cross the limit of div container.
i means to say..my dataTables is crossing the outer div container's border.
and it also showing me a error like:
"Object doesn't support this property or method"
"jquery.dataTables.js Line :3709"
Please help me to sort out this problem...Its very urgent for me.
i just to draw my datatable inside div container not outside it.
I am sending my code ..may be i have done something wrong there...please check it to solve my problem..
Thanks in advance...
Java Script Code :
[code]
oTable = $("#ft").dataTable({
"bDestroy":true,
"bRetrieve": false,
"bJQueryUI": true,
"bServerSide": true,
"bAutoWidth": false,
"sScrollX": "100%",
"sAjaxSource": "/web_trial_one/DatasourceGsonServlet?button_name="+button_id+"&txt_mtr_from="+str_from_mtr+"&txt_mtr_to="+str_to_mtr,
"bProcessing": true,
"sPaginationType": "full_numbers",
"sDom": 'T<"clear">lfrtip', //'<"H"Tfr>t<"F"ip>' to print tabletool in UI theme within border.
"oTableTools": {
"aButtons": [ "copy","csv","xls","pdf",
{
"sExtends": "download",
"sButtonText": "Download Excel",
"sUrl": "/web_trial_one/FTDownload?txt_mtr_from="+str_from_mtr+"&txt_mtr_to="+str_to_mtr+"&txt_cca_from="+str_from_cca+"&txt_cca_to="+str_to_cca+"&txt_catcode="+str_catcode+"&txt_assemb="+str_assemb+"&txt_clem="+str_clem+"&txt_tariff="+str_tariff+"&txt_mask_id="+str_mask+"&txt_site="+str_site+"&txt_cca_test_from="+str_cca_test_from+"&txt_cca_test_to="+str_cca_test_to+"&txt_ft_test_from="+str_ft_test_from+"&txt_ft_test_to="+str_ft_test_to
}
],
"sSwfPath": "./table_tool2.0/media/swf/copy_cvs_xls_pdf.swf"
},
"fnInitComplete": function() {
new FixedColumns( oTable, {
"iLeftColumns": 5,
"iLeftWidth": 420
} );
}
});
[/code]
HTML Code :
[code]
CCA No.
Test Date
Meter Serial No.
Stage
SO Number
Product Code
Meter Test Status
Tested By
Site Name
Test Name
test Value
Test Code Status
Batch No.
Loading Data From Server...
[/code]
I am facing some critical problem in dataTables.
Right now i am using dataTable with serverside processing.
Actually my table contains large no. of columns...so i just want to implement FixedColumn with server side processing.
So according to dataTable's documentation i used FixedColumn and initialized it in dataTable.
As a result..when dataTable implements..it doesn't follow FixedColumn property.. and dataTables columns cross the limit of div container.
i means to say..my dataTables is crossing the outer div container's border.
and it also showing me a error like:
"Object doesn't support this property or method"
"jquery.dataTables.js Line :3709"
Please help me to sort out this problem...Its very urgent for me.
i just to draw my datatable inside div container not outside it.
I am sending my code ..may be i have done something wrong there...please check it to solve my problem..
Thanks in advance...
Java Script Code :
[code]
oTable = $("#ft").dataTable({
"bDestroy":true,
"bRetrieve": false,
"bJQueryUI": true,
"bServerSide": true,
"bAutoWidth": false,
"sScrollX": "100%",
"sAjaxSource": "/web_trial_one/DatasourceGsonServlet?button_name="+button_id+"&txt_mtr_from="+str_from_mtr+"&txt_mtr_to="+str_to_mtr,
"bProcessing": true,
"sPaginationType": "full_numbers",
"sDom": 'T<"clear">lfrtip', //'<"H"Tfr>t<"F"ip>' to print tabletool in UI theme within border.
"oTableTools": {
"aButtons": [ "copy","csv","xls","pdf",
{
"sExtends": "download",
"sButtonText": "Download Excel",
"sUrl": "/web_trial_one/FTDownload?txt_mtr_from="+str_from_mtr+"&txt_mtr_to="+str_to_mtr+"&txt_cca_from="+str_from_cca+"&txt_cca_to="+str_to_cca+"&txt_catcode="+str_catcode+"&txt_assemb="+str_assemb+"&txt_clem="+str_clem+"&txt_tariff="+str_tariff+"&txt_mask_id="+str_mask+"&txt_site="+str_site+"&txt_cca_test_from="+str_cca_test_from+"&txt_cca_test_to="+str_cca_test_to+"&txt_ft_test_from="+str_ft_test_from+"&txt_ft_test_to="+str_ft_test_to
}
],
"sSwfPath": "./table_tool2.0/media/swf/copy_cvs_xls_pdf.swf"
},
"fnInitComplete": function() {
new FixedColumns( oTable, {
"iLeftColumns": 5,
"iLeftWidth": 420
} );
}
});
[/code]
HTML Code :
[code]
CCA No.
Test Date
Meter Serial No.
Stage
SO Number
Product Code
Meter Test Status
Tested By
Site Name
Test Name
test Value
Test Code Status
Batch No.
Loading Data From Server...
[/code]
This discussion has been closed.
Replies
Allan
There are some of few issues related to above post..which i am facing right now ..sorry i skipped to write in above post...The issues are as following :
1. When i used FixedColumn with server side processing( like above code)..at that time horizontal scroll bar is not appearing...While if i used Client side processing then it works fine and "sScrollx" feature is also working.
2. This one is most unusal like.. When dataTable populates beyond the div container, Its showing two tags...you can see it in attached image..still i am not getting that how its possible..??
3. When dataTable (from above code) populates..its showing me an error like:
[code]
"Object doesn't support this property or method"
jquery.dataTables.js Line: 3709
[/code]
To show all above issues.. I've added a screenshot here: http://i.imgur.com/1iptQx4.png
You can check in above attached link that my dataTable is expanding and going beyond the div Border (Black color)..
Please..Please help me to sort out these problem...its very important for my existing application..
and Sorry @allan ..i am not able to send a link for test case..Because if i send the above code in link as test case...it would also require data that should be populate in dataTable..and without those data you will not able to check the proper output of test case..so i think its not possible to send test case.
So please sort out my problem through post and above above attached screenshot..
i just want to use FixedColumn property with server side processing..
Thanks in advance..
I am waiting for your reply..
Allan