Search

The tbody is inside of the foreach loop. Move it outside and it will work as expected. At the moment every row has a tbody, rather than there just being a single tbody (which currently is all DataTables supports). Allan

I'm afraid DataTables currently works with a single tbody element in the table only. Multiple tbody support is something I'd like to add in future, but to be honest that is probably quite a while off. You'd need to change the output to use a single tbody only or use jQuery to modify the DOM so there is a single tbody only before the DataTable is initialised. Allan

Ahhh. Thank you so much Allan. I should have read the doc carefully. It works just fine now.

If you attach a click event listener to the th element before you initialise the DataTable, your event will be executed first (since jQuery just executes them in sequential order). edit or a better way of removing a row by id? Use row().remove() with an id selector for row(). Allan

This is what I ended up with: c9.express.dataTable.rows({search:'applied', order:'applied'}).eq(0).each( function(index){ Thanks.

when i clicked on table header , then that column not sorted by its own value

Great news :) Please mark this thread as solved.

I think you should be getting a Javascript error shown in your browser's error console. You most certainly should if you use $.fn.tbl.moment. It doesn't appear that the Moment plug-in for DataTables is being included on your page. I would suggest you use: $.fn.dataTable.moment("YYYY-MMM-DD"); $(document).ready( function () { $("#SearchResultsDataTable").DataTable(); }); Selecting the element outside of the document ready function don't seem to make much sense to me - you'd be as well not having the document ready function at all. Allan

Fix it with CSS.

I'm interested in the case you are working on where you don't know the number of columns. Why using count-1 is harder?