Forum Discussion

sehajpalsinghj's avatar
sehajpalsinghj
Ideator I
9 years ago

join the data of multiple item type using aml

Hi, I am new to this platform. Suppose I have an item type Part with two properties that is part ID and Part Name  and the other Item Type is Supplier with properties partID and Suplliers wherein for one partID there can be multiple Suppliers. Is there any aml query or any other way where in we can  fetch the result which consist part ID , Part Name and Supplier as output of the query
AML

1 Reply

  • Yoann_Maingon's avatar
    Yoann_Maingon
    Ideator I
    9 years ago
    Hi, You take it the wrong way. Have you tried to model that in Aras? I believe you want to create a Part Itemtype (Don't waste this time, use the one that is out of the box) Then create a supplier Itemtype, with a relationship to Parts. Create this and then you can use AML to do your query if the Aras UI is not enough. And by the way the datamodel you mention exists with a Supplier Ref itemtype.