[CAY-1732] how to fetch the data from the related tables by checking the condition on second table column?

• Type: Task
• Status: Closed
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 3.1M3
• Fix Version/s: 3.1
• Component/s: Database integration
• Environment: Struts2.3 with Apache cayenne and MySql database
• Assignee: Unassigned
• Reporter: Sampath
• Created: 09/Aug/12 13:16
• Updated: 09/Oct/12 08:13
• Resolved: 09/Oct/12 08:13

Description

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.