Can i use disjunction with associated entity using criteria

husny · **Joined:** Sun Dec 19, 2010 9:09 am **Posts:** 2

Hi all

i have a two tables

class class1
{

String text1
...
List<Class2> list;
}

Class Class2
{
String text2
}

the condition i have to make is

text1 like "value" OR text2 like "value"

how can i make this relation with criteria
thanks ...

chirag.naikec · **Posted:** Mon Dec 20, 2010 6:51 am

Try this,

Code:

criteria.add(Restrictions.or(Restrictions.ilike(text1, value),Restrictions.ilike(text2, value)));

Hope this will help you.

Chirag

husny · **Joined:** Sun Dec 19, 2010 9:09 am **Posts:** 2

thanks

that cant run because the text2 property in different criteria (sub criteria )

chirag.naikec · **Posted:** Mon Dec 27, 2010 12:51 am

Ya but you can use class two property also.