Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,996
Community Members
 
Community Events
165
Community Groups

Equivalent of "activeUsers()" in JQL?

We have scriptrunner and "inactiveUsers()" works great in the following scenario:

   assignee in inactiveUsers()

However we have some fields that can take multiple users, thus the following shows both tickets with only an invalid Product Owner as well as tickets with both a valid and an invalid Product Owner. How do I write JQL that will show only tickets that only have invalid Product Owners?

   "Product Owner" in inactiveUsers()

What I want to say is

   "Product Owner" in inactiveUsers() and "Product Owner" not in activeUsers()

but there appears to be no opposite of inactiveUsers() - activeUsers() does not exist in JQL.

I tried this but it did not work:

   "Product Owner" in inactiveUsers() and not "Product Owner" not in inactiveUsers()

1 answer

2 votes

Hi,

Sadly you cannot achieve the desired search using neither standard features on Jira nor Script Runner for Jira, you must go for a different third-party app instead. If you are on Server/DataCenter, using i.e. JQL Booster Pack you can type the following:

 

1) Search for issues having an invalid Product Owner

"Product Owner" in inactiveUsers() AND "Product Owner" NOT IN activeUsers()

(*) Note that this is just an example, you must tune above query to fit your needs.

 

Using this app you can also query other user properties, check:

 

References:

Kind Regards

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you