hi, facing problem in following type of Relational Traversal scenario,
Team has list of Members. Each Member has name and gender.
Now I have to select Teams by applying condition on its members
e.g. Select all such Teams which contains members satisfying following condt. (gender is 'Male' and name starts with 'S') AND (gender is 'Female' and name starts with 'A')
i.e. I want to select all such teams which has atleast 1 'Male' whose name starts with 'S' atleast 1 'Female' whose name starts with 'A'
Not getting how to form query for such requirement.
I tried few ways but unable to find solution.
Please help
|