Hibernate Community • View topic - How to apply and restriction on alias

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to apply and restriction on alias

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

dandan

Post subject: How to apply and restriction on alias

Posted: Mon Feb 15, 2010 10:25 am

Newbie

Joined: Mon Dec 25, 2006 4:59 am
Posts: 15

Hi guys

I need help on creating a detached criteria which will use alias (with inner join) only if the aliased object is not null.

in criteria i am using LEFT_OUTER_JOIN, but this argument is not available in detached criteria. Is there any way, besides to do it in detached criteria ?

Code:

        criteria.createAlias("element", "alias", JoinFragment.LEFT_OUTER_JOIN);
        Criterion criterion1= Restrictions.isNull("element");
        Criterion criterion2= Restrictions.eq("alias.something", false);
        criteria.add(Restrictions.or(criterion1, criterion2));

thanks

Top

dandan

Post subject: Re: How to apply and restriction on alias

Posted: Tue Feb 16, 2010 4:20 am