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,300,969
Community Members
 
Community Events
165
Community Groups

JQL query I created is showing closed tickets

Edited

The below query is still pulling Closed tickets from the project and I am not sure if I am just writing the query wrong or what other cavats I am missing here. 

 

project = "PROJECT" AND comment ~ term1 OR comment ~ term2 AND status not in (Closed, resolved)

 

Thank you for your help

1 answer

1 accepted

4 votes
Answer accepted
Jack Brickey Community Leader May 02, 2022

Can you try this...

project = "PROJECT" AND (comment ~ term1 OR comment ~ term2) AND status not in (Closed, resolved)

Dirk Ronsmans Community Leader May 03, 2022

@Orry Wright-Larson ,

Just a little context here, you should consider an OR statement as a break in your JQL. Any thing you introduce an OR (without enclosing it in brackets) it will break up your query.

So in your example you basically said:

project = "PROJECT" AND comment ~ term1

OR

comment ~ term2 AND status not in (Closed, resolved)

 

So your second status limitation does not reflect the first part. The way Jack mentions it you'll actually use both OR comments as a single statement and all AND's will be concatenated.

Like Jack Brickey likes this
Jack Brickey Community Leader May 03, 2022

@Orry Wright-Larson , pleas let us know if this works or if have further questions.

Suggest an answer

Log in or Sign up to answer
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