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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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

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

@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)

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

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.

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.

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

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
Site Admin
TAGS
AUG Leaders

Atlassian Community Events