Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Organization details filtering in queues

Greg
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 4, 2024

On an Organization, we have a Detail called "Region". The goal here is to filter queues using that Region.

OrgDetails.jpg

As far as I can see, Organization Details can't be used in queue filters, so I thought we could write this attribute into a custom field on the issue and then filter that way.

I thought I could achieve this through automation to set the issue region based on the organisation region when an issue is created using:

1.  A smart value, but it appears Organization Details aren't included as smart values.

2. Accessing the API using Organization Properties, but it seems that organisation properties are different to the Organization Details I'm trying to extract.

Is there any way to achieve this?

1 answer

1 vote
Fernando Eugênio da Silva
Community Champion
January 4, 2024

@Greg , Welcome to the Atlassian Community!

Please, take a look at this documentation: Create queues based on customer details | Jira Service Management Cloud | Atlassian Support

I believe that documentation can help you with build a JQL based on Organization Details.

Mike Bodé April 21, 2025

I am attempting to setup service plans as detail fields on organizations and then setup the queues based on those service plans. I've tried to use the syntax listed in that document and none of that works. Organizations IN will attempt to match on specific organizations, and Organizations IN OrganizationDetails("Service Plan", "Platinum") [like in the example] is invalid JQL syntax. If you attempt to save with any of those stated examples for the organization, it will say Unable to find JQL function 'organizationDetails(Service Plan, Platinum)'. It doesn't seem like their stated approach works.?

Alain Kovacs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 19, 2025

I did not know this was possible and given that Jira is very limited in what it can do with the "detail" fields, this is simply fantastic! Thanks @Fernando Eugênio da Silva 

@Mike Bodé I confirm this works

Mike Bodé May 19, 2025

How did you get it to work? @Alain Kovacs I never get the JQL OrganizationDetail function but only get Organization as valid call. The organization only provides list of customers, whereas getting the detail field doesn't seem to work for me. 

Alain Kovacs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 20, 2025

So these are the details of one of my customer organizations:1.jpg


Then my JQL is like this:

2.jpg

organizations in organizationDetail("Category (DO NOT MODIFY)", "INT") AND created >= -30d AND project = CS ORDER BY created DESC

Suggest an answer

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

Atlassian Community Events