You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2012/10/09 13:06:02 UTC

[jira] [Closed] (CAY-1730) how to fetch the data from the related tables by checking the condition on second table column?

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

Andrus Adamchik closed CAY-1730.
--------------------------------

    Resolution: Won't Fix

replied on the user list. 
                
> how to fetch the data from the related tables by checking the condition on second table column?
> -----------------------------------------------------------------------------------------------
>
>                 Key: CAY-1730
>                 URL: https://issues.apache.org/jira/browse/CAY-1730
>             Project: Cayenne
>          Issue Type: Bug
>            Reporter: Sampath
>            Priority: Critical
>
> I am using apache cayenne 3.X with Struts2.3.4 version
> I have query:
> 	SELECT * FROM t_task_assignment_detail t0 where t0.user_id=112 and exists (select 'X' from t_task_transaction_detail t1 where t1.id = t0.task_transaction_id and t1.task_status='INPROGRESS') 
> In the above query the two tables having the relationship.
> T_task_transaction_detail
> T_task_assignement_detail
> I want fetch the data from T_task_assignement_detail table where task_status is “inprogress”.
> Now I am using the above query to fetch the data but how to achieve the same using cayenne?
> Thanks,
> Sampath Uppula.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira