It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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