We need to find comments where only one user is mentioned, but two employees have similar logins.

ArinaMat

 

Hello! Please help me solve the problem

 

There are two people with the same last name in my company. I need to find all the tasks where one of them was tagged. But since their usernames are similar, JQL returns results for both employees.

 

Example: I need to find tasks where an employee with the login "smith" is mentioned. The JQL query looks like this: comments ~ smith


And this query returns results for both the employee with the login "smith" and the employee with the login "smith.am".

 

Search by token does not work, we do not have an ID, the operator !~ / brackets / quotation marks did not help either

Shawn Doyle - ReleaseTEAM

Hi @ArinaMat 

The search ~ smith is too greedy as you have found out.  It will find any occurrence of the letters smith in the comment.

The best approach is to search by userid. 

comment ~ <User ID>

However if they are not being mentioned, and it's just a username text you are searching for, Try adding the white space ~ ' smith ' this will change the search to include a leading and trailing space.  

comment ~ ' smith '

If this weren't the comment field, I would suggest not using the ~ operator and use =