This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Criteria createAlias with addtional restrictions

Ka Erol
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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 ?

Kind regards
Karol R.
I agree. Here's the link:
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic