Hibernate Search using Criteria with OR condition.

[Vijay Gadde]

Hi, I need to write a dynamic search querry in my Hibernate application.

For the same I am using this Criteria API to build the querry dynamically bellow is code

Criteria criteria = session.createCriteria("com.xx.beans.MyProfile").setMaxResults(51);
if(searchRequestData.getEmailAddress()!=null && searchRequestData.getEmailAddress()!=""){
criteria.add(Expression.like("emailAdd","%"+searchRequestData.getEmailAddress()+"%" ));}
if(searchRequestData.getFirstName()!=null && searchRequestData.getFirstName()!=""){
criteria.add(Expression.like("subsNumber", searchRequestData.getCirculationNameID()));
}
criteria.add(Restrictions.like("siteId",1);
criteria.add(Restrictions.like("siteId",11);
List searchResults= criteria.list();

When I run this querry, the querry its generating with AND conditions like below

select top 51 
this..........from USER_PROFILE this_ where this_.email_add like ? 
"and" this_.site_id like ? "and" this_.site_id like ?

as I mentioned in double quotes its using AND condition, but I want to use OR condition can some help to how can i do this.

Thanks in advance,VIJAY

[ntumba lobo]

to do a OR with the criteria API you can use

Restrictions.or(criterion1,criterion2)

[Vijay Gadde]

Thanks for that quick reply, I got big confusion with this Restrictions.OR(Criterian1, Criterian2).

If I will get 5 differnet integer values, so its like
select * from USERS where
user_name like 'vij%' or
type=1 or
typ=2 or
type=3;

But this Restrictions is like between two values only, but I need to make it for all the values dynamically could you please help how to fix this..!
Thanks,VIJAY

[Paul Sturrock]

For that particular query, qould you not be better using an InExpression? Is that not logically the same?

[Vijay Gadde]

Hi Paul,
Yes that work I had used like below

criteria.add(Expression.in("USER_TYPE", arrayListUserTypes));

Thanks for all that, vijay