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 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 14: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 14: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 19: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: Tue Sep 16 05:13:30 GMT 2014

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

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