This example shows how FixedColumns can be used with server-side processing in DataTables to cope with very large tables. The only special thing to consider here is that the FixedColumns instance must be initialised once the table has completed its full initialisation - this is done using fnInitComplete.
| Rendering engine | Browser | Platform(s) | Engine version | CSS grade |
|---|---|---|---|---|
| Rendering engine | Browser | Platform(s) | Engine version | CSS grade |
$(document).ready( function () {
var oTable = $('#example').dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "../../examples/server_side/scripts/server_processing.php",
"sScrollX": "100%",
"sScrollXInner": "150%",
"fnInitComplete": function () {
new FixedColumns( oTable );
}
} );
} );