Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Are Azure AD Sync attributes exposed to JQL or must the attribute be first mapped to a custom field?

I'm new to JQL and trying to build a filter that will allow our agents to quickly identify any issues that are unassigned and are in their local sites. Azure AD Sync is populating the City details for the reporter once an issue is raised but I can't seem to get to that data in my JQL query. 

Essentially what I want to achieve is something like;

Project = "IT Service Desk" AND City ~ 'City / Site Name' AND Assignee IN (Empty) AND Status NOT IN (Closed, Completed, Canceled, Cancelled, Done, Resolved)

Any help will be greatly appreciated.

Thanks, Mark

1 answer

Hi @Chadwick, Mark ,

Sounds like you have configured Azure AD Attributes from the projects Project Settings menu.

In order to use JQL you need to be a Jira admin and set up field sync by going to Settings - Apps - Azure Ad Attributes Sync - Synchronization

From here you map a new field that you will be able to include in a later JQL query.

More info from the vendor found here -> Mapping Azure AD data to a custom field


Hope it will work for you as it does for me.



Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Safe customer notifications in Jira Service Management for compliance and privacy needs

Announcing safe customer notifications in Jira Service Management as a building block for compliance and privacy needs At Atlassian, we understand the increasing need to be assured that your data i...

340 views 1 14
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you