How to query or filter by organization custom fields

[Tom Oritt]

In our JSM project, each issue/ticket is associated with an external Organization.  We have created dozens of custom Organization fields.  How can we create a query like:

List all tickets where Organization custom field ABC = "XYZ" for the ticket's associated Organization(s)?

[Aaron Pavez _ServiceRocket_]

Hi @Tom Oritt 

Just like any other custom field. JQL will be for each custom field = org name for example.

Is anything not working when running the JQL? The JQL auto-fill can help you create the query,

Regards

Aaron

[Tom Oritt]

Thanks, Aaron.  Let's say I've created a custom Org field called "Services".  If I write the JQL like this:

project = "Customer Production Support" and Organizations.Services = "ABC"

I get this error:

Field 'Organizations.Services' does not exist or you do not have permission to view it.

Maybe I have the wrong syntax.

The JQL autocomplete shows me that the "Organizations" field itself is cf[10002], but how do I specify my custom Org attribute (like "Services") in the JQL?