I have an entity Shipment with a sub-entity Packing and a sub-sub-entity Material and I want to consolidate the info at Material-level for a single shipment and return that info to another microflow. I have used following OQL script, but an error remain: SELECT SUM(Mat/Item_customs_value_amount) as Cons_constoms_val, SUM(Mat/Item_quantity) as Cons_qty, SUM(Mat/Item_net_weight) as Cons_net_wght, SUM(Mat/Item_gross_weight) as Cons_gross_wght FROM MyFirstModule.Shipment as Ship INNER JOIN Ship/MyFirstModule.Packing_Shipment/MyFirstModule.Packing/MyFirstModule.Material_Packing/MyFirstModule.Material as Mat GROUP BY Mat/Item_tariff_number, Mat/Item_country_of_origin, Mat/Item_unit Could you please advise? Regards, Arno
Assuming that you mean as follows, the error remains:
The domain Model as follows:
hello Arno ,
so the problem is with join condition you put join in one condition you have to place two Joins in your OQL query.