How to add groupBy in service .xml

[Ramakrishnan Sinduja, modifié il y a 7 années.]

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

[Amos Fong, modifié il y a 7 années.]

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, modifié il y a 7 années.]

Thank You , I have managed to achieved this .