AQL for multiple selection

[Andreas Ummenhofer]

Hey Atlassians,

I want to filter an assets field based on the selection of another assets field.

So when I select the "Generation" I only want to see all objects from above selected "Model"

This AQL and field config work with a single selected object, but not with multiple:

"Modell" IN (${customfield_10086})

customfield_10086 = Model

Configuration of Custom Field "Generation":

Filter scope (AQL): objecttype = Generation

Filter issue scope (AQL): "Modell" IN (${customfield_10086})

Allow search filtering by these attributes: Generation

Object attributes to display on issue view: Generation

Field can store multiple objects: Yes

any idea why I can only select one item based on Model?

Thank you :) 

[Jeroen Poismans · Accepted solution]

Hi there,

Have you tried this:

"Modell" IN (${customfield_10086{0}})

The {0} is for multiple values. Could not find it in the Cloud docs, but again might still work on Cloud:
https://confluence.atlassian.com/servicemanagementserver/advanced-placeholders-1044784599.html

Jeroen

[Andreas Ummenhofer]

Thanks @Jeroen Poismans :) 

I just tried with your query, but doesn´t work unfortunately:

"The AQL query contains one or more placeholder values that are invalid or incorrectly formatted."

[Andreas Ummenhofer]

@Jeroen Poismans I found wht´s been missing. Just a simple $ :) 

This AQL works!

"Modell" IN (${customfield_10086${0}})

[Jeroen Poismans]

Sorry Andreas,

That typo was on me, docs that I linked indeed state the extra "$" which I forgot modifying the example to your case.

Glad it solved the issue!

[Jeroen Poismans]

If you would be so kind to Accept the answer so it is marked Solved for future visitors.

Thanks!

[Andreas Ummenhofer]

Sure will do @Jeroen Poismans 
Thank you for your help!