[ 
https://issues.apache.org/jira/browse/JDO-778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Michael Bouschen updated JDO-778:
---------------------------------
    Description: 
I propose to add the following overloaded subquery methods to support 
correlated subqueries using a relationship field of the from clause of the 
subquery, e.g.

{{select firstname from org.apache.jdo.tck.pc.company.Employee }}
{{  where this.weeklyhours > }}
{{     (select AVG(e.weeklyhours) from this.department.employees e where 
e.manager == this.manager)}}

{{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}> 
subquery(CollectionExpression<Collection<{color:#20999d}E{color}>, 
{color:#20999d}E{color}> candidateCollection, String candidateAlias);}}
 {{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}> 
subquery(ListExpression<List<{color:#20999d}E{color}>, {color:#20999d}E{color}> 
candidateList, String candidateAlias);}}
 {{<{color:#20999d}K{color}, {color:#20999d}V{color}> 
JDOQLTypedSubquery<Map.Entry<{color:#20999d}K{color}, {color:#20999d}V{color}>> 
subquery(MapExpression<Map<{color:#20999d}K{color}, {color:#20999d}V{color}>, 
{color:#20999d}K{color}, {color:#20999d}V{color}> candidateMap, String 
candidateAlias);}}

  was:
I propose to add the following overloaded subquery methods to support 
correlated subqueries using a relationship field of the from clause of the 
subquery, e.g.

{{select firstname from org.apache.jdo.tck.pc.company.Employee }}
{{ where this.weeklyhours > }}
{{    (select AVG(e.weeklyhours) from this.department.employees e where 
e.manager == this.manager)}}

{{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}> 
subquery(CollectionExpression<Collection<{color:#20999d}E{color}>, 
{color:#20999d}E{color}> candidateCollection, String candidateAlias);}}
 {{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}> 
subquery(ListExpression<List<{color:#20999d}E{color}>, {color:#20999d}E{color}> 
candidateList, String candidateAlias);}}
 {{<{color:#20999d}K{color}, {color:#20999d}V{color}> 
JDOQLTypedSubquery<Map.Entry<{color:#20999d}K{color}, {color:#20999d}V{color}>> 
subquery(MapExpression<Map<{color:#20999d}K{color}, {color:#20999d}V{color}>, 
{color:#20999d}K{color}, {color:#20999d}V{color}> candidateMap, String 
candidateAlias);}}


> Adding overloaded methods to JDOQLTypedQuery to create a correlated subquery 
> -----------------------------------------------------------------------------
>
>                 Key: JDO-778
>                 URL: https://issues.apache.org/jira/browse/JDO-778
>             Project: JDO
>          Issue Type: Improvement
>          Components: api
>    Affects Versions: JDO 3.1
>            Reporter: Michael Bouschen
>            Priority: Critical
>             Fix For: JDO 3.2
>
>
> I propose to add the following overloaded subquery methods to support 
> correlated subqueries using a relationship field of the from clause of the 
> subquery, e.g.
> {{select firstname from org.apache.jdo.tck.pc.company.Employee }}
> {{  where this.weeklyhours > }}
> {{     (select AVG(e.weeklyhours) from this.department.employees e where 
> e.manager == this.manager)}}
> {{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}> 
> subquery(CollectionExpression<Collection<{color:#20999d}E{color}>, 
> {color:#20999d}E{color}> candidateCollection, String candidateAlias);}}
>  {{<{color:#20999d}E{color}> JDOQLTypedSubquery<{color:#20999d}E{color}> 
> subquery(ListExpression<List<{color:#20999d}E{color}>, 
> {color:#20999d}E{color}> candidateList, String candidateAlias);}}
>  {{<{color:#20999d}K{color}, {color:#20999d}V{color}> 
> JDOQLTypedSubquery<Map.Entry<{color:#20999d}K{color}, 
> {color:#20999d}V{color}>> subquery(MapExpression<Map<{color:#20999d}K{color}, 
> {color:#20999d}V{color}>, {color:#20999d}K{color}, {color:#20999d}V{color}> 
> candidateMap, String candidateAlias);}}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to