CODEWITHSUNDEEP
liferayliferay-6
user3855589
user3855589

Reputation: 1103

Group by Dynamic query in liferay

I have simple question about dynamic query in liferay.. How can i use group by in dynamic query

For ex: select date_,count(*) from Clipping group by date_;

How can i do this in liferay dynamic query?

Please help

Thanks

Upvotes: 0

Views: 3345

Answers (1)

Andrea Di Giorgi
Andrea Di Giorgi

Reputation: 967

Try this:

    DynamicQuery dynamicQuery = ClippingLocalServiceUtil.dynamicQuery();

    ProjectionList projectionList = ProjectionFactoryUtil.projectionList();

    projectionList.add(ProjectionFactoryUtil.groupProperty("date"));
    projectionList.add(ProjectionFactoryUtil.rowCount());

    dynamicQuery.setProjection(projectionList);

    List<Object[]> results = ClippingLocalServiceUtil.dynamicQuery(dynamicQuery);

Upvotes: 2

Related Questions