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

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? 

Hi Eli,

thanks for the ideas! I made some progress and at the same time you opened Pandora's box.

The original idea was that I reuse my custom "all-purpose-all-in-one view". It´s a single Method that renders the result of an AML query to a simple table in a pop-up window. See following example. It uses a AML query to collect all documents hidden in the multiple BOM levels:

That´s why I asked for the plain AML query - cause I wanted to use the same building technique to "save time" (worked well so far). 

As this kind of rendering is basically a simplified QD/TGV clone, there is of course nothing wrong with using the original QD/TGV combo. The resulting view is basically the same and QDs can deal with referencing items. Perfect!

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

There were none - before I tested it. In my environment it doesn't work, but it´s not the fault of Innovator. It´s my federated data that I pull via an onGet query.

My current federation solution is optimized to display federated data in the client (including grid relevant functionality like filter options, paging, etc.). See: Best way to highlight (fully) federated data in grids and views? 

Now I learned that my federated data isn't perfect enough for AML queries. My "crafted" item properties mainly consist of id and keyed_name. With id and keyed_name they work as clickable links in grid and Forms, but they doesn't work in QDs.
I think we can tell the reason when we look a the data structure of similar ItemTypes (like Manufacturer Part with the Manufacturer item property). Typically item properties use a bit more data:

I am right now a bit unsure of what to do. 

- Use an additional server Method (as you suggested)
- Rework my federation solution so I can use QD?
- Make an additional federated view that already contains all the data?
- I also got some ideas from another community member that I don´t need to over engineer everything and there is nothing wrong in using more than one AML query to get the data.

I think I'll let the problem sit for a while and hope it resolves itself.  It´s a fun challenge, but it´s just there because my users are spoiled. In the past people would have been totally fine with an SSRS report for this kind of view.

Edit: In QD I right now get following error message when testing the query:  <faultstring>Item attribute 'itemTypeName' not set !</faultstring> . In only appear when my custom federated ItemType is included. For testing purposes I added various additional attributes, but couldn´t get rid of the error message.