Right AQL for Asset field required

[Nicole_Brueckner]

Dear community, 

We face the following issue: 

We have 2 Asset Object Fields, which are not referenced to each other. Just two "normal" picker fields.

In some projects we have references, in others we don't. Therefore we added a context for the projects, where a reference needs to be implemented. We achieved this with the following:

• Category as an Objecttype is selected in the first customfield 18601 (Field is called "Affected Object")
• Module is selected in customfield 18602 (called "Affected configuration") with the AQL: Category in ${customfield_18601} 

So far so good: 

We have now a new use case, where in 18601 the category need to be a multi select. The Module field will be then empty, as no module is in both categories.

 

We want to achieve, that the dropdown will show all modules from the selected categories. (Like the normal referenced fields, but as described, thats not possible). 

I already tried: object having outR(Category = ${customfield_18601}) but this is also not working. 

In the asset it is configured like this: On the module I select the Category Object:

Thats the whole config of the asset field:

Any ideas?

Best regards,

Nicole

[Stefan Stadler · Accepted solution]

Hi @Nicole_Brueckner 

I would assume this is not working due to some conversion between array values.

I had a look at the following documentation:

JSM Data Center - Assets - How to configure Assets Object custom field based on another Assets Object custom field | Jira and Jira Service Management | Atlassian Support

There it is also mentioned to use the following if specifying an "in" clause:

Category IN (${customfield_18601${0}})

Those parenthesis are important when handling array objects/fields.

Can you try that? 

And does it work, if you are using "Category = ${customfield_18601}" and only select one category?

Hope this helps!

Stefan

[Nicole_Brueckner]

Hi @Stefan Stadler

Thanks for this! This works brilliant and as I hoped for. 

You made this day a little better! Thank you very much. 

Best regards-,

Nicole