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