Criteria Or, ilike on Joined Columns

theoverture · **Joined:** Fri Sep 10, 2010 9:57 am **Posts:** 1

I'm trying to use Criteria to implement adhoc queries on tables that have multi-tiered relationships.

Code:

Criteria c = session.createCriteria( CaseReview.class );
c.createAlias( "reviewCase" , "reviewCase"); 
c.createAlias( "reviewCase.studentInformation" , "reviewCasestudentInformation");
c.add( Restrictions.or( Restrictions.ilike("reviewCasestudentInformation.lastName" , "%e%" ), Restrictions.ilike( "reviewCasestudentInformation.firstName" , "%e" )));
c.list();

Where my studentinformation entity has a firstName and lastName attributes, my CaseReview has a reviewCase entity, and my reviewCase entity has a studentInformation attribute.

I end up getting a

Code:

org.hibernate.QueryException: could not resolve property: reviewCasestudentInformation of: CaseReview

which doesn't make any sense to me. The exactly same alias works fine when using the Order api

Code:

// This code works absolutely fine after creating the aliases above
sortOrder = Order.asc("reviewCasestudentInformation.lastName");
criteria.addOrder(sortOrder);
c.list();

I'm about ready to give up. Any suggestions?

saltnlight5 · **Posted:** Sat Sep 11, 2010 4:01 pm

You might want to try this:

Code:

Criteria c = session.createCriteria( CaseReview.class );
c.createAlias( "studentInformation" , "si");
c.add( Restrictions.or( Restrictions.ilike("si.lastName" , "%e%" ), Restrictions.ilike( "si.firstName" , "%e" )));
c.list();

Read http://docs.jboss.org/hibernate/stable/ ... sociations