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 04:45 Go to next message
Marcial Atienzar is currently offline Marcial Atienzar
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
Re: How can I add extra join conditions with left joins [message #525418 is a reply to message #525322] Tue, 06 April 2010 10:24 Go to previous messageGo to next message
James Sutherland is currently offline James Sutherland
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
Re: How can I add extra join conditions with left joins [message #525423 is a reply to message #525418] Tue, 06 April 2010 10:32 Go to previous messageGo to next message
Marcial Atienzar is currently offline Marcial Atienzar
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
Re: How can I add extra join conditions with left joins [message #527033 is a reply to message #525423] Tue, 13 April 2010 15:09 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

See,

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


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


Current Time: Sat Apr 19 06:12:52 EDT 2014

Powered by FUDForum. Page generated in 0.01605 seconds