A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Node.js in Action
this week in the
Object Relational Mapping
Criteria createAlias with addtional restrictions
Joined: Feb 19, 2013
Feb 19, 2013 17:24:04
I'm looking for solution how to add additional restriction do left outer join.
Actually I'm using:
crit.createAlias(VcInternalMail.PROPERTY_COMPANIES_RECIPIENT, "imc", CriteriaSpecification.LEFT_JOIN).add(Restrictions.eq("imc.idCompany", companyList));
But this give me restriction in where clause.
I want to get something like that
left outer join vc_internal_mail_company imc on imc.idInternalMail = this_.idInternalMail and imc.idCompany in (13)
Is it possible with Criteria ?
I agree. Here's the link:
subject: Criteria createAlias with addtional restrictions
left outer join Vs right outer join
Querying Based On Member of Contained Collection
Stumped on a SQL Statement
Left outer join
are these join same
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014