usersWithProperty()

Description:

Perform searches based on users with a matching user property value.

Note:
User properties managed by Jira and LDAP attributes are not related in any way, as a consequence, you cannot query LDAP attributes using this custom JQL function.
To learn how Administrators can add new user properties, please check 'Add a property to a user' section at this Atlassian Jira Documentation Page.

Syntax	usersWithProperty(propertyKey, value)
Available since	v1.1.0-RELEASE
Supported fields	Assignee, Reporter, Voter, Watcher, custom fields of type User
Supported operators	`IN , NOT IN`
Unsupported operators	`= , != , ~ , !~ , > , >= , < , <=` `IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED`

Examples:

• Find issues that have been reporter by users of 'Fuyisoft' company :

reporter IN usersWithProperty("company", "Fuyisoft")

Real World Use Cases:

· JRASERVER-30228 - Enhance JQL to include User Properties (by Alan Lewis)
· Can I report based on user properties? (by Rita YOUNES [Infosysta] at ATLASSIAN Community)
· issueFunction to get user property in a JQL query (by mel vega at ATLASSIAN Community)
· How to create jql filter wherein we can get value attached to user? (by Christian Michael Arizala at ATLASSIAN Community)

JQL Function Reference