Skip to Content
0

Join two Tables in ODATA

Jun 22, 2017 at 10:15 PM

79

avatar image

Hi there :)

Is it possible to Join two Tables on a certain Key in the ODATA Services on a XSODATA File ?

What i have now looks like this:

and i want it to look something like this, which would work :

I thank you a lot in Advance!

1.png (14.8 kB)
2.png (21.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
Nov 14, 2017 at 07:14 PM
0

Hello ,

you can try for example the following:

service{

"SCHEMA"."OBJECT_CHANGE_REQUEST" as "OBJ_CH_REQ"

navigates("ObjectLines" as "ObjectToLines");

"SCHEMA"."LINE_CHANGE_REQUEST" as "LI_CH_REQ";

association "ObjectLines" principal "OBJ_CH_REQ"("ID") multiplicity "1"

dependent "LI_CH_REQ"("OBJ_ID") multiplicity "*";

}

Maybe you need to change the multiplicity.

I hope this helps!

Kind regards,

Alex

Share
10 |10000 characters needed characters left characters exceeded