How to add groupBy in service .xml

[Ramakrishnan Sinduja, modificado 7 Anos atrás.]

I want to show the data group by Name and Sent Date in custom JSP. How to achieve this.Please Help.

[Amos Fong, modificado 7 Anos atrás.]

Currently, "group by" is not an option in service builder. You can make a "group by" select query by creating a custom finder:
https://dev.liferay.com/develop/tutorials/-/knowledge_base/6-2/developing-custom-sql-queries

[Mrs Raghavan, modificado 7 Anos atrás.]

Thank You , I have managed to achieved this .