1 of 1 people found this helpful
I suppose you are using EJB2.1 CMP because of the query syntax, right?
A sub-select is not possible in this case, you have to use EJB3 (JPA-QL) for this.
What you can do if you have a relation is something like
SELECT OBJECT(o) FROM WorkflowEntry o, IN (o.currentSteps) step WHERE o.state = ?1 AND step.owner = ?2 AND step.status = ?3
You must have a CMR in this case!
Thank you, that helped me.
I don't have CMR and yes, this is EJB2.1 CMP.
I think about a change to EJB3.