Content Comparison

Excerpt

Perform searches based on active users that belong to the provided group.
See also: inactiveUsers()

Note:
If no group is provided, it will return all users set as active in the system.

Syntax	activeUsers() activeUsers(group, ...)
Available since	v2.3.1-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`

• Find issues that have been created by any active user in 'EMEA' or 'LATAM' projects:

Code Block

language	sql
theme	Confluence

creator IN activeUsers() AND project IN ("EMEA", "LATAM")

• Find bugs reported by currently inactive users:

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

• Find issues in which their 'Managers' field (múltiple user picker) are assigned to inactive users only:

Code Block

language	sql
theme	Confluence

Managers IN inactiveUsers() AND Managers NOT IN activeUsers()

· Equivalent of "activeUsers()" in JQL? (by Mike Shkolnik at ATLASSIAN Community).

JQL Function Reference

Page Tree

root	JQL Function Reference
startDepth	2

Versions Compared