How to add groupBy in service .xml

[Ramakrishnan Sinduja, modificado hace 7 años.]

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

[Amos Fong, modificado hace 7 años.]

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 hace 7 años.]

Thank You , I have managed to achieved this .