Skip to Content

Join two Tables in ODATA

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded