OQL-script error when consolidating data

0
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  
asked
3 answers
1

Assuming that you mean as follows, the error remains:

answered
0

The domain Model as follows:

answered
0

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.

firstly join table 1 and 2 

then table 2 and 3   

 

EDIT

 

Regards

Sanjay Kushwah

answered