Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


What is the JQL for not in the list of Request participant?


I'm having trouble running my automation rule where I'd like to do a schedule run, 

My jql search query is like this,

When scheduled run every Friday
JQL search query > Issue type = X AND Status in (A,B,C) AND ("Request participants" not in (NameOfParticipantA) OR "Request participants" not in (NameOfParticipantB))

^ this rule reads all the issues  which are 10000 issue

I think there's something wrong with my query. Please help me understand the query.
I tried replacing it the 'not in' with '!=' it still reads all the 10000 issue.

What I want is that if the specific request particpant is already present in the ticktet for Example NameOfParticipantA OR NameOfParticipantB, then that's the only issues it will read

2 answers

2 accepted

2 votes
Answer accepted
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Nov 02, 2023

@Amarillas Erika -

Are you trying to only get a listing of issues where those specific requested participants are not associated with the issues?

If so, you just need to use the following modified JQL

Issue type = X AND Status in (A,B,C) AND "Request participants" not in (NameOfParticipantA, NameOfParticipantB)

On the other hand, if you want to get a listing of issues where those specified requested participants are associated with the issues, then the JQL will be

Issue type = X AND Status in (A,B,C) AND "Request participants" in (NameOfParticipantA, NameOfParticipantB)

By the way, are you trying to pull in every JSM project in your site for the JQL, or you are just looking for issues from a specific project?  For it is for a specific project, then you will need to add in your JQL with "project = projectkey" before the rest of your JQL query above.

Example (note you don't need to specified the issuetype as it is not required) - 

project = ACME and Status in (A,B,C) AND "Request participants" in (NameOfParticipantA, NameOfParticipantB)


Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

0 votes
Answer accepted

Hello @Amarillas Erika ,

Try to switch your JQL search to basic to make sure your requirement get precise as you looking for. 

and then filter it using request participant field which user you want to find.

for example like this 

2023-10-31 09_24_09-Window.png

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events