Foren
How to get distinct value based on year & month from date column using DQ
RAVI RAJAMANI, geändert vor 6 Jahren.
How to get distinct value based on year & month from date column using DQ
Regular Member Beiträge: 123 Beitrittsdatum: 07.12.14 Neueste Beiträge
Hi,
How to get distinct value based on year & month from date column(ex- Display date column) using Dynamic Query.
Regards,
Ravi
How to get distinct value based on year & month from date column(ex- Display date column) using Dynamic Query.
Regards,
Ravi
RAVI RAJAMANI, geändert vor 6 Jahren.
RE: How to get distinct value based on year & month from date column using
Regular Member Beiträge: 123 Beitrittsdatum: 07.12.14 Neueste Beiträge
Hi ,
Solution
Regards,
Ravi R
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