This question is locked. New answers and comments are not allowed.
Hi,
I'm new to OA so not sure of the best way to tackle the following simplified scenario.
I have a parent entity that contains several collections of differing child types.
I want to only populate the child types based on various criteria. For instance just get the children of a parent entity that are between a date range.
I can't figure out how to do this in ogl. I can't see how the child is linked back to the parent, there isn't an id field present in the child entity.
I looked at fetch groups but we have a large amount of data and we know at runtime what subsets we need so thought it would be easier to query the related child entities and just bring into scope the data we require.
In straight SQL I would do this like:
Thanks,
I'm new to OA so not sure of the best way to tackle the following simplified scenario.
I have a parent entity that contains several collections of differing child types.
I want to only populate the child types based on various criteria. For instance just get the children of a parent entity that are between a date range.
I can't figure out how to do this in ogl. I can't see how the child is linked back to the parent, there isn't an id field present in the child entity.
I looked at fetch groups but we have a large amount of data and we know at runtime what subsets we need so thought it would be easier to query the related child entities and just bring into scope the data we require.
In straight SQL I would do this like:
select |
ch.* |
from |
child ch |
inner join |
parent_child pc |
on pc.child_id = ch.child_id |
inner join |
parent p |
on p.parent_id = pc.parent_id |
where |
p.project_id = 20 |
Thanks,