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

Question

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 ~ "@" AND resolution in (Unresolved, "In Progress") AND NOT comment ~ "" comment ~ "Name approve" AND comment ~ "@" AND resolution in (Unresolved, "In Progress") AND comment !~ "" 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 · Answer

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.

Mila_jy94l1 · Answer

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 ~ "@" comment ~ "" 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 · Answer

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 ~ "" 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 ~ "@" ) AND NOT filter = "Your Filter Name"