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
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.