Hello,

i have the following simple tables:

Table 1: NAME
Field1: NAME_ID
Field2: NAME

Table 2: NAME_ALIAS
Field1: ALIAS_ID
Field2: NAME_ID
Field3: ALIAS_NAME

So every NAME-object has a set of NAME_ALIAS objects.

I want to select all NAME objects that have a String like "123" in NAME.NAME OR NAME_ALIAS.ALIAS_NAME. I tried the following but it doesn´t work:

Criteria crit = getSession().createCriteria(Name.class);
crit.add(Restrictions.or(Restrictions.ilike("name", "%" + name + "%"),
Restrictions.ilike("nameAliases.aliasName", "%" + name + "%")));

Hope anyone can help me...

Thanks and best regards
Sysbeast

Are you trying to do something like this? (scroll to bottom)

http://www.javalobby.org/articles/hibernatequery102/

thanks for you help... i tried somethink like this now:

createCriteria(Name.class)
.createAlias("nameAliases","alias")
.add(Expression.or(Expression.ilike("alias.alias", "%" + name + "%"), Expression.ilike("name", "%" + name + "%")))
.list();

But this criteria is only selecting me object swith the search string in the alias table but not in the name table.

I need all "Name" objects with the search string in "Name.name" OR "Name.nameAliases.alias" ...

Hope someone can realy help me... thanks and best regards
Sysbeast

I tried the criteria you posted (on some of my objects) and it appears to do what you're asking of it. Maybe try looking at/posting the sql statement it generates.