I have 4 tables in this situation.
Parent->child->grandchild->great-grandchild
I have a TypedList of the Parent. I would like to create a filter for the Parent that will yield a list of Parents that contain a corresponding great-grandchild.
After using and reviewing FieldCompareSetPredicate, I've realised that it alone will not get me the proper result, because it looks at only one other table for "in" or "exists"
I, in fact, need this ability:
select * from "ParentTypedList" p where p.Pid in
(select pid in child c where c.cid in
(select cid from grandchild gc where gc.gcid in
(select gcid from great-grandchild ggc)
)
)
I KNOW that I COULD retrieve using other means, however, I'd like to filter on my TypedList for the parent.
Is there some way to "nest" the compareset predicate class objects?
Thanks,
Darren