Group By in server side scripting

ican.jayesh

Hello Allan

I am using server side scripting method to generate datatable But I don't khow how to apply group by in sql query

Thanks

allan

Hi,

The demo ssp.class.php script doesn't support GROUP BY operations I'm afraid. You would need to either modify it to suit your needs, or create your own script that would work that way.

Allan

p.s. I've deleted your duplicate question. Please don't post duplicates.

ican.jayesh

Hi Allan,

Thanks for your support and Sorry for duplicate post..
But i am not use ssp.class.php i am use following method to generate table

https://editor.datatables.net/examples/simple/server-side-processing.html

Thanks

allan

Okay - thanks, I wasn't aware that you were using Editor. I'm sorry to say that Editor currently does not support grouping and aggregation methods. That is something I hope to add in future, but it is not something that is currently possible.

Regards,
Allan