How do you "OR" criteria together when using a criteria query with hibernate?

Question

I'm trying to do a basic "OR" on three fields using a hibernate criteria query.

Example

class Whatever{  string name;  string address;  string phoneNumber; } 

I'd like to build a criteria query where my search string could match "name" or "address" or "phoneNumber".

Answer 1

You want to use Restrictions.disjuntion(). Like so

session.createCriteria(Whatever.class)     .add(Restrictions.disjunction()         .add(Restrictions.eq("name", queryString))         .add(Restrictions.eq("address", queryString))         .add(Restrictions.eq("phoneNumber", queryString))     ); 

See the Hibernate doc here.

Answer 2

Assuming you have a hibernate session to hand then something like the following should work:

Criteria c = session.createCriteria(Whatever.class); Disjunction or = Restrictions.disjunction(); or.add(Restrictions.eq("name",searchString)); or.add(Restrictions.eq("address",searchString)); or.add(Restrictions.eq("phoneNumber",searchString)); c.add(or);