Hibernate version: 3.2.0

Hi experts,
I have to filter a record for multiple values of a column. I have a table say "TBL" and have a field say "f". Now i need to apply a condition
as given below


I think i can do it using the following statement:


as far as i know the above statement will produce something like:


but my problem is, at runtime i know how many values (x, y, z) need to be checked against the property 'f';

How do i do that using Criteria API

thanks in advance

Hi,
Here is Java way of doing it.
Build criteria at run time.

org.hibernate.criterion.Property myProperty = Property.forName("f") ;
Disjunction or = Restrictions.disjunction() ;
for(String value : values)
or.add(myProperty.like(value)) ;
session.createCriteria(Tbl.class).add(or).list() ;

where, values is of type List<String> and holds values for comparison. ( 'x' , 'a' .... )

-------------------------------------------------
Rate the reply if you find it helpful

Thanks

It is working fine.