Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Filter Issue scope (AQL) for Assets using "Organizations"

Tobias Bosshard January 24, 2023

I would like filter assets objects using the (locked) field "Organizations".
Example:
The reporter is part of a organization in the jira project (e.g. PowerWorker). The machines (objects in assets) have a field like "company".
Now, I would like filter the machines (from field "company" e.g. PowerWorker) using the (locked) field "Organizations" (customFieldId=10002). How should be the string for the Filter issue scope (AQL)?
Thanks a lot for any advise!
BR Toby

4 answers

1 accepted

1 vote
Answer accepted
Rodney Dsouza _Atlassian Certified Expert_
Contributor
August 14, 2023

@Tobias Bosshard, @AV , @Dylan Robinson 

 

Although this is possible on Jira Server/Data Center, it is NOT POSSIBLE on Cloud as of right now.
The fact that it has been possible on DC has created a few web pages on the internet giving us false hope/indication that it would work on Cloud.
" Placeholders cannot be used in the Filter Scope (AQL) field in the Assets Objects Field Configuration screen."
However, that does NOT appear to be true _anymore_ since I have personally successfully used issueType as a placeholder in Filter Scope (AQL).
Looking at the documentation for Cloud, we see that some fields are supported on Cloud now, but unfortunately not Organizations.
Here are some Suggestions that you can upvote if you want this feature worked on (but I suggest you don't hold your breath)
Tobias Bosshard August 14, 2023

Dear Rodney,
thank you very much for your summary.
Yes, all we can do is vote and wait...
BR Toby

1 vote
Dylon Robinson
Contributor
May 11, 2023

Attempting to use a similar function

Object attribute: Location

Filter scope: Location = ${customfield_10002}

Does not work

Filter scope: Location = "NAMEOFORGANIZATION"

Does work

We really need an option to dynamically filter based on this locked field.

1 vote
AV
Contributor
February 21, 2023

I am actually trying this exact thing and found your post, so far I can't get it to work either.

I have an asset with a field called 'ShowForOrganisation'.
In there i Just type the Organisation's name which I want the field to be shown for.

Then in AQL i try to filter it:
ShowForOrganisation = "NAMEOFORGANISATION" > this works perfectly
however when I try the same trying to use the Organisations field:
ShowForOrganisation = ${customfield_10002} > this does not work

I tried fiddling a bit with customfield_10002.name or.label, but that doesn't seem to work.

So After this I found out the Organizations field can contain more then 1 value, which would mean the query should be like this:
ShowForOrganisation IN (${customfield_10002${0}})

Unfortunately I didn't get this to work either. I am currently still trying to achieve this.

0 votes
Tobias Bosshard February 15, 2023

As it seems, there is currently no solution to this. Is that correct?

Amos
Contributor
October 22, 2023

I'm currently trying a very similar thing and it would appear that there is no way to dynamically look up custom fields (despite the example in https://community.atlassian.com/t5/Jira-Service-Management-articles/Announcing-Filter-Issue-Scope-for-Insight/ba-p/1737942). 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events