Eclipse Community Forums: EclipseLink » How can I add extra join conditions with left joins

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

Eclipse User

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

Eclipse User

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.

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

Eclipse User

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

Eclipse User

See,

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

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

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Aug 31 00:05:29 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter