Filter Issue - can't find all issues with the mentioned person either in text/tag in the comment

[Mila]

Hello,

Since I am helping my manager in consolidating JIRA tickets.

Here's the two scenarios:

1. How to find the ones mentioned my manager(either in text or @name) in the comment which require her apporval? and the condition also include her deputy also not yet added the approval in the comment?

I have used the two following but cannot find issues:

comment ~ "Name approve" AND comment ~ "@<Name>"  AND resolution in (Unresolved, "In Progress") AND NOT comment ~ "<Deputy Name>"

 comment ~ "Name approve" AND comment ~ "@<Name>"  AND resolution in (Unresolved, "In Progress") AND comment !~ "<Deputy Name>"

2.  I have used the following: 

comment ~ "First Name approve" AND resolution in (Unresolved, "In Progress")

Then I tried to add Last Name in it, it showed nothing.
However, there are issues containing the exact First Name+Last Name in the comment section. 

Please kindly help on this!

Thanks :)

[Bastian Stehmann]

Hi Mila,

welcome to this community.

I think it is a problem with AND and OR. Additionally, the resolution is usally not set until the issue is closed, so you have to check there for an empty resolution as well.

Maybe you can try something like this

(comment ~ "Name approve" OR comment ~ "@<Name>" ) AND (resolution in (Unresolved, "In Progress") or resolution IS EMPTY) AND NOT comment ~ "<Deputy Name>"

[Mila]

Hi Bastian,

Thanks for the reply!

I have tried just now, I removed the resolution part from the search.

Usinig the following:

(comment ~ "First Name approve" OR comment ~ "@<First and Last Name>" ) AND NOT comment ~ "<Deputy's Name>"

However, issues with deputy's name in the comment will still pop up.

Wondering why... 

[Bastian Stehmann]

Hi @Mila,

sorry, just did not recognize that all comments will be checked, as is described here: 

https://community.atlassian.com/t5/Jira-questions/Jira-Advanced-Query-for-searching-text-in-a-comment-field-in-a/qaq-p/48175

Can you try the following:

create and save a filter with the query 

comment ~ "<Deputy's Name>"

This should give you all issues with comments including the Deputy's Name.

Then use this JQL to get the issues you want:

(comment ~ "First Name approve" OR comment ~ "@<First and Last Name>" ) AND NOT filter = "Your Filter Name"

[Mila]

Hi Bastian,

Thanks again.

I tried just now and Deputy's comment will still showed up!

I tried to set a filter using both: 

comment ~ " Name" OR comment ~ "@<First+Last Name>" 

comment ~ "<Deputy's Name>"

Then search again as you instructed, but one of the issue ticket with Deputy's comment will still pop up.

Any other suggestion?  

I searched previous questions and wondering would it be possible to NOT include "commented by Deputy"?

[Bastian Stehmann]

Hi Mila,

did you add the NOT before the filter = -part of the query?

This should then filter out all issues that have a comment including the deputy's name.

If you add the NOT in the filter with the deputy's name, it will give you all issues with at least one comment that does not contain the deputy's name.