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.


SyntaxusersWithProperty(propertyKey, value)
Available sincev1.1.0-RELEASE
Supported fieldsAssignee, Reporter, Voter, Watcher, custom fields of type User
Supported operatorsIN , 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