additional conditions in join clauses

ouzo · **Joined:** Wed May 05, 2004 8:01 am **Posts:** 53

I have a query that I found needs an additional condition in join clause. Is this kind of feature planned in Hibernate?

Example:

Code:

select dr.id, dr.dueDate, c.name, sd.name, d.id, d.name 
from Survey s right outer join s.dueReport dr *** with s.merchandiser = ? *** 
join dr.surveyDefinition sd join sd.contractor c, 
Merchandiser m 
join m.tasks t join t.depot d 
where s is null 
and t.surveyDefinition = sd 
and m = ? 

Briefly saying the query searches for all surveys that have not been done by particular user. There might be another same surveys made by other users so I need to introduce addional condition in right outer join.

I might also use subselect - the problem is my database is MySQL and this feature is also not available.

Without the solution I will end up with making one master query and thousands details query (list all "tasks" and check if they have been done by particular user by querying survey existence). The number of queries will also grow in time making the function call last longer and longer.

emmanuel · **Posted:** Thu Jul 15, 2004 7:36 am

No AFAIK but you can vote for this issue in Jira 'or create it)

ouzo · **Joined:** Wed May 05, 2004 8:01 am **Posts:** 53

Is there such entry already or should I create a new one? I am browsing for it but can't see anything like that.

emmanuel · **Posted:** Thu Jul 15, 2004 8:02 am

can't remember, create a new one