How to get distinct value based on year & month from date column using DQ

[RAVI RAJAMANI, modificado 6 Anos atrás.]

Hi,

How to get distinct value based on year & month from date column(ex- Display date column) using Dynamic Query.

Regards,
Ravi

[RAVI RAJAMANI, modificado 6 Anos atrás.]

Hi ,
Solution

DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(
				xyz.class, PortalClassLoaderUtil.getClassLoader());

		dynamicQuery
				.setProjection(ProjectionFactoryUtil.distinct((ProjectionFactoryUtil
						.sqlProjection(
								"year(displayDate) as year , month(displayDate) as month",
								new String[] { "year", "month" }, new Type[] {
										Type.INTEGER, Type.INTEGER }))));

Regards,
Ravi R