Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Duplicate
-
3.1M3
-
None
-
Struts2.3 with Apache cayenne and MySql database
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.