search

IgnitedDatatables / Ignited-Datatables

Ignited Datatables is a wrapper class/library based on the native Datatables server-side implementation by Allan Jardine found at http://datatables.net/examples/data_sources/server_side.html for CodeIgniter
285 stars 335 forks source link

group_by and order_by don't work when I use both in a query #49

Closed techjewel closed 6 years ago

techjewel commented 10 years ago

At first, Thanks for a wonderful library. I have a situation where I have to join 2 table and I have to use join and group_by function to join with the latest row of a group of rows.

But when I try to use that don't work.

Would you please give me a solution of that.

Thanks

widnyana commented 10 years ago

mind if I ask what query do you execute?

afxkumar commented 9 years ago

Same Issue Fatal error: Call to undefined method Datatables::order_by()

blagi commented 9 years ago

There is no order_by() in Ignited Datatables. Query order is constructed based on data from Datatables. There is initial order and later on you are defining order by clicking on columns.

putul commented 8 years ago

you can do it by using this $this->db->order_by('column_name','asc/desc');