joining user table?

11 views

Skip to first unread message

surya...@gmail.com

unread,

Aug 31, 2015, 6:12:59 AM8/31/15

to Liferay Savvy

ClassLoader classLoader = PortletClassLoaderUtil.getClassLoader("loopdbservices_WAR_loopdbservicesportlet");
DynamicQuery auditlogquery = DynamicQueryFactoryUtil.forClass(AuditEventLog.class, "logalias", classLoader);
DynamicQuery eventquery = DynamicQueryFactoryUtil.forClass(AuditEventDetails.class, "eventalias", classLoader);
DynamicQuery userquery = DynamicQueryFactoryUtil.forClass(User.class, PortalClassLoaderUtil.getClassLoader());

userquery.setProjection(ProjectionFactoryUtil.property("userId"));
userquery.add(PropertyFactoryUtil.forName("userId").eqProperty("logalias.userId"));
auditlogquery.add(PropertyFactoryUtil.forName("userId").in(userquery));
List<AuditEventLog> ret=AuditEventLogLocalServiceUtil.dynamicQuery(auditlogquery);
System.out.println("size of list is"+ret.size());