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 =

[ArinaMat]

Hi  @Shawn Doyle - ReleaseTEAM  ! 

Thank you for your response! I appreciate your help. However, I find that the option with UserId doesn't quite meet my needs, as I'm unable to recognize this entity, as mentioned earlier. I do have a token, but it seems that Jira doesn't search for it.

This is a system field for a comment, and I specifically need to mention the user using "@". Since the comment includes other text alongside the username, the = operator may not be suitable for my situation.

[Shawn Doyle - ReleaseTEAM]

Hi @ArinaMat 

= is not suitable and I didn't suggest it would be.

When you mention you have a token, what do you mean?  Are you confusing token with a userid?

[ArinaMat]

.