How to make a criteria query with 3 OR Criterions properly?

Question

I'd like to make a criteria query with 3 OR Criterions and I dont know what is the best way to do it.

Currently I only have 2 or Restrictions.

Criteria crit = session.createCriteria(Reader.class)
.add(Restrictions.or(Restrictions.like(PUBLICATION_ID_FIELD, "Question",MatchMode.END), Restrictions.like(PUBLICATION_ID_FIELD, "Idea",MatchMode.END)));

How can I add a third one ?

score 18 · Accepted Answer · answered May 02 '11 at 16:44

You can either "or" one more restriction to the result:

Criteria criteria = session.createCriteria(Reader.class);
criteria.add(Restrictions.or(Restrictions.or(condition1, condition2), condition3));

or use Disjunction:

Criteria criteria = session.createCriteria(Reader.class);
Junction conditionGroup = Restrictions.disjunction();
conditionGroup.add(condition1).add(condition2).add(condition3);
criteria.add(conditionGroup);

score 0 · Answer 2 · edited May 23 '17 at 12:02

0

You may refer to this link for more detailed explanation for conjunction and disjunction

How to use Hibernate Criteria objects for multiple and/or conditions

edited May 23 '17 at 12:02

Community

1
1

answered Aug 15 '16 at 17:15

James

456
6
14

To prevent link rot, please explain the major points of what is described in your link. – litelite Aug 15 '16 at 17:41

How to make a criteria query with 3 OR Criterions properly?

2 Answers2