Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Jira Advanced Query for searching tickets without a specified comment

Michal Hoffman September 8, 2015

Hello,

 

I want to filter out all tickets that I think are done. All I can do in the queue is commenting tickets. So I want to use it to comment 'ItsDone' tickets that I don't want to see anymore.

 

project = XXX AND NOT comment ~ ItsDone AND reporter in (YYY)

This doesn't work

 

So I tried

 

Filter1
project != XXX AND comment ~ ItsDone AND NOT reporter in (YYY)

filter !~ Filter1

But still did not worked

 

Advise please.

 

Thank You Mike

3 answers

1 accepted

0 votes
Answer accepted
Michal Hoffman September 8, 2015

Team that manages the queue has a bad habit of changing status to resolved even if ticket is not resolved, because they did their part and they don't care. Other teams don't use jira.

 

Resolution:

filter1:

comment ~ ItsDone

 

 

filter2:

project = XXX AND reporter in (YYY) AND filter !=filter1
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 8, 2015

I'd change the workflow and process to block that.

0 votes
Joe Pitt
Community Champion
September 8, 2015

Sounds like it's time to give someone a couple days off without pay smile

0 votes
Joe Pitt
Community Champion
September 8, 2015

Is there a reason you aren't just looking for tickets where the resolution field isn't null ? 

Suggest an answer

Log in or Sign up to answer