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")))); 

 

Leave a Reply

Your email address will not be published. Required fields are marked *