掲示板

DynamicQuery DISTINCT DATE_FORMAT

7年前 に ildar sl によって更新されました。

DynamicQuery DISTINCT DATE_FORMAT

Regular Member 投稿: 158 参加年月日: 11/12/12 最新の投稿
Hi all!

How to Query "SELECT DISTINCT DATE_FORMAT(createDate,'%Y') from blogsentry"?


DynamicQuery dq = DynamicQueryFactoryUtil.forClass(BlogsEntry.class);
dq.addOrder(OrderFactoryUtil.asc(F_CREATE_DATE));
dq.add(RestrictionsFactoryUtil.eq(F_GROUP_ID, groupId));

Projection projection = ProjectionFactoryUtil.distinct(ProjectionFactoryUtil.property(F_CREATE_DATE));
    	dq.setProjection(projection);

List<blogsentry> result = BlogsEntryLocalServiceUtil.dynamicQuery(dq);
</blogsentry>


How to write this is the place DATE_FORMAT (createDate, '% Y')?