Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description:

Excerpt

Perform searches based on inactive users that belong to the provided group.

If any no group is provided, it will return all users set as inactive in the system.


SyntaxinactiveUsers()
inactiveUsers(group, ...)
Available sincev1.0.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 created by any inactive user in 'EMEA' or 'LATAM' projects:

Code Block
languagesql
themeConfluence
creator IN inactiveUsers() AND project IN ("EMEA", "LATAM")


• Find bugs reported by any active user:

Code Block
reporter NOT IN inactiveUsers() AND issuetype = Bug


• Find issues that are assigned to inactive users of group 'HelpDesk L1':

Code Block
languagesql
themeConfluence
assignee IN inactiveUsers("HelpDesk L1")

Real World Use Cases:

· Finding Issues Owned by Inactive Users with JQL (by KYLE at ATLASSIAN Community).
· JRASERVER-34168 - Add functionality to JQL to search for inactive users (by Jens Kretzschmar)
·
How do I assign issues owned by an inactive user to an active user? (by Mark Seymour at ATLASSIAN Community)
· How can I looking for issues that created by inactive user? (by Sara Asis at ATLASSIAN Community)






JQL Function Reference

Page Tree
rootJQL Function Reference
startDepth2