Organization details filtering in queues

Question

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

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?

Alain Kovacs · Answer

So these are the details of one of my customer organizations:

Then my JQL is like this:

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

Mike Bodé · Answer

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 · Answer

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