Search

could not recognize constants or variables which are declared in external files. They can, but you need to use the use() statement: ->where( function ( $q ) use ( $CONST_STATUS_START, $CONST_GROUP_EMPTY ) { This is all part of PHP's awful handling of globals and variable scope... I quite like PHP, but it does have issues such as this - particularly if you are used to Javascript. Allan

Look for "Use as a function to create a link from the data source:" in this example: https://datatables.net/reference/option/columns.render

Also it looks like the recalc function never gets called when the browser maximizes, un-maximizes, or snaps to the side of the screen atleast in windows 8 running chrome 40

Use the bServerSide option if you are using a legacy version of DataTables. serverSide is the new option. Allan

Finally figured this out. Updated code var oTable = $('#SensorData').DataTable( { "bServerSide": false, "order": [[2, "desc"]], dom: 'T<"clear">lfrtip', tableTools: { "sSwfPath": "assets/swf/copy_csv_xls_pdf.swf", "aButtons": [ { "sExtends": "copy", "mColumns": [1, 2], "oSelectorOpts": { filter: "applied", order: "current" } }, { 'sExtends': 'xls', "mColumns": [1, 2], "oSelectorOpts": { filter: 'applied', order: 'current' } }, { 'sExtends': 'print', "mColumns": [1, 2], "oSelectorOpts": { filter: 'applied', order: 'current' } }, { 'sExtends': 'pdf', "mColumns": [1, 2], "oSelectorOpts": { filter: 'applied', order: 'current' } }, { 'sExtends': 'csv', "mColumns": [1, 2], "oSelectorOpts": { filter: 'applied', order: 'current' } } ] }, "columnDefs": [ { "targets": [0], "visible": false, "searchable": false } ] });

Hi I've now managed to solve. I was convinced the data via Ajax included all the rows as the records count indicated the correct number. I drilled further and discovered an error in the php laravel package that forced a default record limit of 10 if no parameter set. I've now reverted to an earlier version of the package and all resolved. Not a databases issue but a data issue Thank you for the pointer

Can you link me to the page then please, so I can debug it. Allan

"className": .... http://datatables.net/reference/option/columns.className

Got it - thanks! That comment is nonsense. I'm going to package up a new beta of Editor 1.4 today, and I'll get this sorted out for that. Thanks for flagging it up! Allan

So fast , no time to explain... http://yadcf-showcase.appspot.com/ :)