Search

Gold, thanks @kthorngren !

Hi again @jalil , Those are class "paginate_button", so you could see if you're doing anything special with those. If not, we're happy to take a look, but it would help, as per the forum rules, if you could link to a running test case showing the issue so we can offer some help. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here. Cheers, Colin

Hi, Where do you want to show the resulting calculation? The Editor libraries don't support GROUP BY in the data loaded and edited by Editor I'm afraid, but you could use the $db->sql() method if you just want to execute that and get the data. Allan

Thanks again @allan. This is just what I was looking for, I appreciate it.

Hi @ronald_wouters , There's no easy way, I'm afraid. This example here allows sorting, but you it won't display the arrow indicators unfortunately. I've added it to the feature request for DataTables 2.0, so it may appear in the near future. Cheers, Colin

Multiple fields in left join function? I don't think that this is possible with Editor. And I didn't see a hint on this in the page Colin pointed out. But do you really need a LEFT JOIN or is an INNER JOIN ok as well? You can always do an INNER JOIN using the WHERE clause. Of course you can use multiple fields an that where clause. This thread discusses an example: https://datatables.net/forums/discussion/comment/116150/#Comment_116150

Thank you @colin That was really helpful.

Something like this example? http://live.datatables.net/porixida/1/edit You can use the dom option to control the placement of Datatables elements. The record count is the i paramteer. Kevin

Thanks Allan, It was late, I should have seen that. Thanks man. Thanks for the example Colin! Craig

If you look at that fifth example again, you'll see it's manipulating the data for that column, which is exactly what you want to do...