We have a situation where we need to join multiple child objects of a data model.
e.g.
ProjectInformation (Datamodel Object)
_time
host
..........
ChildOne (Datamodel Child Object)
_time
host
............
field1
CalculatedField2
ChildTwo(Datamodel Child Object)
_time
host
............
field 1
CalculatedField3
ChildThree(Datamodel Child Object)
_time
host
............
CalculatedField3
CalculatedField4
We would like to have a result with following fields:
CalculatedField2; CalculatedField3; CalculatedField4 by field1
where field1 value for ChildThree should be evaluated from ChildTwo.field 1 where ChildTwo.CalculatedField2 = ChildThree.CalculatedField2
Can you define all of the calculated fields at the top level data model?