Filter issue Scope AQL based on different Assetfield

[Daniel Eiternick]

Hi there,

I have a Custom Asset Field, where one chooses an object of type "Product". This field works.

The ObjectType "Product" has an Attribute named "Included Services", referencing multiple Obects of Type "Service"

In my custom request, I want to have two fields, the first to pick the product, and the second custom field should only offer "service" objects that are listed in the selected products "Included Services" Attribute.

How do I need to write the AQL für the Services Selecting Custom field? 

My idea was something like 

ObjectID IN ${Productpickerfield.Included Services}, but it doesnt work

I tried with Name instead of ObjectID, tried putting quotes around the "Included Services" and tried double brackets {{, and putting the included services outside the brackets, nothing seems to be right. I guess I am approaching this not from the right angle?

[Daniel Eiternick · Accepted solution]

Sadly I found this, dot notations are not working in the Custom field configurations:  https://jira.atlassian.com/browse/JSDCLOUD-10481

[Fabian Lim]

Hi @Daniel Eiternick

Here is the article that you need that explains on what you need to do: https://community.atlassian.com/t5/Jira-Service-Management-articles/JSM-Linking-Insight-Custom-Fields/ba-p/2054341

Regards,

Fabian

[Daniel Eiternick]

Hi @Fabian Lim, that doesn't work, as the second fields assets (Service), does not have an attribute pointing to the products, only vise versa. In addition the Operator "=" doesn't work, as the "Product" object has a list of Services in the relevant  attribute field ("Included Services" can have multiple entries).