Versions Compared

Key

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

Description:

Excerpt

Perform searches based on groups that the given user belongs to.
If any user is provided, it will return all the groups that the current user belongs to.



SyntaxgroupsOf()
groupsOf(user, ...)
Available sincev1.0.0-RELEASE
Supported fieldscustom fields of type Group
Supported operatorsIN , NOT IN
Unsupported operators

= , != , ~ , !~ , > , >= , < , <=

IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

Examples:

• Find issues whose 'QA Team' group picker custom field value is a group that the current user belongs to:

Code Block
languagesql
themeConfluence
"QA Team" IN groupsOf()


• Find issues whose 'Dev Team' group picker custom field value is a group that group that 'John Smith' belongs to:

Code Block
languagesql
themeConfluence
"Dev Team" IN groupsOf("jsmith")

Real World Use Cases:

· JRASERVER-21392 - JQL: add the ability to query for the groups an user is member of (by Leticia Rafaela Rheinheimer)
·
JQL to find all issues where the user's group is in a group customfield? (by Scott Harman at ATLASSIAN Community)
·
JSDSERVER-5003 - JQL groupsOf(user), an inverse of membersOf(group) (by Richard Woodward)





JQL Function Reference

Page Tree
rootJQL Function Reference
startDepth2