Forum Discussion

angela's avatar
angela
Catalyst II
1 year ago

Need help with AML query to connect two independent ItemTypes via referencing item

Hi community, I am working on an AML query but cannot find a proper solution. It contains a lot of custom ItemTypes, but technically the query would work similar like this: START--------> Part...
AML
eli_donahue's avatar
eli_donahue
Community Manager
1 year ago

Hi Angela,

AML itself doesn’t really have the joining capability you’d need here. A query definition would probably be the simplest approach to this type of query.

If you can’t use a QD in this scenario, I’d try creating a custom server method to use as an AML action. 

<Item type=“Part” action=“GetBomWarehouseData” id=“...” />

That approach would enable you to include any additional you need in the AML response.

Out of curiosity - do you have any constraints preventing you from using a Query Definition in this scenario?