Hi,
I'm trying to use criteria.add to add expressions that are grouped together by the sql "or" instead of "and"

for example

criteria.add(Expression.like("field1","value1"));
criteria.add(Expression.like("field2","value1"));

would generate sql like

select * from ... WHERE field1='value1' OR field2="value1"

and not

select * from ... WHERE field1='value1' AND field2="value1"

Does anyone know how to do this?

Restrictions.or(Restrictions.eq(), Restrictions.eq())

Thanks for the tip.
Although I forgot to mention in my first post that I will have multiple "OR" conditions not just two. Could you give me an example how I would test test for say 3 conditions that are grouped by the sql "OR".

I'm a little stuck because it seems the Restrictions.or() method only lets you add 2 expressions (not a list) in its params.

Thanks again.

gigantic method chain outta do it :)

restrictions.or(restrictions.or(eq,eq),restrictions.or(eq,eq))

Take a look at Disjunction.

Disjunction.add(Exp1).add(Exp2).add(Exp3).....add(ExpN)