Browsed by
Month: August 2013

Not In query In Liferay Dynamic Query

Not In query In Liferay Dynamic Query

In Liferay dynamic query you can create a query for not in condition like     SELECT * FROM traders WHERE traderId NOT IN(455,466) dynamicQuery.add(PropertyFactoryUtil.forName("primaryKey.traderId") .notIn(StatutoryLocalServiceUtil.dynamicQuery() .add(PropertyFactoryUtil.forName("primaryKey.traderId").eq(455)) .add(PropertyFactoryUtil.forName("primaryKey.traderId").eq(456)) .setProjection(ProjectionFactoryUtil.property("primaryKey.traderId"))));