Assets Object reference - AQL filter
Hello community,
within Assets I want to show a value in object table from another object table filter on a field within this object.
I have tried multiple things myself, but I do not get the value that I want. My AQL skills are not yet that developed so I was hoping somebody from the community might know how to solve this.
So we have a customer object type where I added a new attribute called "Version Production".
This object links to the customer environment object type (from another object schema), which is called "customer environment".
This object has a attribute called "Installation", which defines if it is a Production (Prod) or a test environment.
And I want to filter for this Prod value for the installation.
Lastly, the version is again its own object type.
Basically my question is, how can I get the Prod installation version into the customer object?
I have documented everything in the attachment.
Let me know if you need to know anything more and thanks in advance!
Cheers,
Simon
