Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » How can I add extra join conditions with left joins
How can I add extra join conditions with left joins [message #525322] Tue, 06 April 2010 08:45 Go to next message
Marcial Atienzar is currently offline Marcial AtienzarFriend
Messages: 6
Registered: April 2010
Junior Member
Hi,

Is it possible to do this query with CriteriaBuilder:

select n
from GnNode n
left join n.nodeRoles r with r.id = 'USER'
where n.activo = 'S'

Lot of tkanks,

Marcial

Report message to a moderator

Re: How can I add extra join conditions with left joins [message #525418 is a reply to message #525322] Tue, 06 April 2010 14:24 Go to previous messageGo to next message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member
This is not supported. Please log an enhancement request.

You either need to put the condition in the where clause, or use a native SQL query.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Re: How can I add extra join conditions with left joins [message #525423 is a reply to message #525418] Tue, 06 April 2010 14:32 Go to previous messageGo to next message
Marcial Atienzar is currently offline Marcial AtienzarFriend
Messages: 6
Registered: April 2010
Junior Member
If i put it on the where clause I'm converting it to an inner, and I don't want it.

Where and how can I put an enhacement?

Lot of thanks,

Marcial

Report message to a moderator

Re: How can I add extra join conditions with left joins [message #527033 is a reply to message #525423] Tue, 13 April 2010 19:09 Go to previous message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member
See,

http://wiki.eclipse.org/EclipseLink/Bugs

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:Weaving now static, reason for concern?
Next Topic:Is it possible to return a Collection inside a multiselect (CriteriaBuilder)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 08:11:04 GMT 2024

Powered by FUDForum. Page generated in 0.19368 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly