Can users that have been mentioned in issues be queried by JQL?

Since the latest 5.1.3 JIRA upgrade the @mention utility has been improved considerably.

I would like to know if there exists any JQL instruction to query in which issues I (or any other user) was specifically "mentioned"?

6 answers

1 accepted

This widget could not be displayed.

Hi Jaques,

it does work with JQL - here for example is a JQL which I use to provide Users with a list of Issues where they have been mentioned during the last 7 days:

(summary ~ currentUser() OR description ~ currentUser() OR comment ~ currentUser()) and updatedDate >= -7d

Thanks Christian!

This does indeed do the job!!

  • (summary ~ "username" OR description ~ "username"  OR comment ~ "username") and updatedDate >= -7d

Very helpful, thanks!

The statement from OP can never work since neither currentUser() nor currentLogin() support the text search operator "~".

The text search can only be made with literals. Cannot really understand the technical reason behind this limitation though.

See currentUser()

strange, I just ran it and it worked as expected. Perhaps it behaves differently based on your Jira installation. 

Binaya KC I'm New Here May 31, 2018

This looks for the user name in the whole comment section. I definitely would NOT want the issues that I commented, I only want the issues that I am mentioned on. So this would not be an ideal solution. @Johan Persson is right. 

This widget could not be displayed.

hi Mirek,

thanks for mentioning this, but I knew this already :)

I just thought that if they add this cool feature that there should be a way to filter for issues where you've been mentioned as they might be issues where you're none of the regular roles (assignee, reporter, watcher,...) that already exist and for which you can filter.

I found this issue talking about this feature: https://jira.atlassian.com/browse/JRA-27594 and as mentioned there (I've also tried in my environment) filtering for @mentions doesn't work.

Let's wait if some more people vote on the forementioned issue to get it implemented.

regards,

Jacques.

This widget could not be displayed.

How do I change current user to another user in the system for this: 

  • (summary ~ currentUser() OR description ~ currentUser() OR comment ~ currentUser()) and updatedDate >= -7d

Not sure why I am having such a hard time! smile

Username = katiethebeau

(summary ~ katiethebeau OR description ~ katiethebeau OR comment ~ katiethebeau) and updatedDate >= -7d

This widget could not be displayed.
Mirek Community Champion Aug 28, 2012

Hi Jacques,

As I know mentioning is only used to share the issue with other users (the same behavior like using Share button) and send a notification. It is not possible to achieve a search who was mentioned in a particular issue.

You can only search for issues that a particular user is watching or voting using:

* watcher

* voter

like for example..

watcher = someone, watcher = currentUser()

If you want that kind of feature you can create a new request. For more information about how Atlassian implement New Features, please see the Implementation of New Features Policy.

I hope that will help

Regards,

Mirek

This widget could not be displayed.

Hi all,

I am using the following JQL to create a filter on @mentions:

comment ~ currentUser() and updatedDate >= -30d

It works, however, when I've gone and deleted the comments I was mentioned in (they were for testing the filter) - they still show up in the search! Is the JQL searching the history and not the comments that actually exist? Is there another JQL that will only display the items I'm still actively mentioned in?

This widget could not be displayed.

I'm using JIRA OnDemand (6.2 as of right now I think?).. and this does not work as I expected

I expect to get a list of issues where I have been mentioned using @ + myname

However, I do get a list of issues where my name has been mentioned as text in a comment, but not as an actual @mention

Anyone having this same problem?' What is the JQL query for this?'

I tried the JQL: comment ~ currentUser()

In Jira On Demand, this worked for me. I guess it is case sensitive.

project = ABCD AND comment ~ CurrentUser()  ORDER BY created 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

143 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you