I'm a newbie to Hibernate and I have been using HQL for the most part. I had a situation to where I need to build a very dynamic query and I thought the criteria api might the better choice.

However, I need to use SQL OR operations in my where clause.

So far, I have not found an example online or in Hibernate in Action that shows how to do this.

In addition, I'm looking to do this with the criteria api if possible:

HQL Sample:



I thought I would just ask the forum since some google searching wasn't getting me anywhere!

Thanks,

Mike

P.S. I'm Using Hibernate 3.2.2

Use the below one



sess.createCriteria(Entity.class).createAlias("customProperties", "resultProperty")
.setProjection(Projections.property("entityResult"))
.add(Expression.or(Expression.and(Expression.eq("resultProperty.id",id),Expression.eq("resultProperty.value",value)),....)


PS : please don't forget to give credits below if you found this answer useful :)