It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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"?

10 answers

1 accepted

25 votes
Answer accepted

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. 

Like NancyB455 likes this

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. 

I did not find that to be true.  This query comment ~ currentUser() ORDER BY created DESC only found where I had been mentioned with an @ sign, not when I had created a comment. (JIRA Server, 7.13.1)

doesn't work for me. comment ~ currentUser() doesn't find the issue I'm mentioned on. 

but comment ~ "hello" finds it.

Mentions created in the new issue view will not be found in queries. Please vote for this issue! 

https://jira.atlassian.com/browse/JRACLOUD-72207

Thanks, silly question. how do I vote for that, where the vote link ?

Not silly at all! On the right hand side under the reporter, click This affects my team. I took a screenshot for you, but attaching it isn't working. 

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.

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

0 votes
Mirek Community Leader 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

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?

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 

I know this is an old question, but I just ran this JQL and noticed that it only returns issues where currentUser() is mentioned in the LAST comment.  It didn't locate issues where currentUser() was mentioned in other comments besides the last one.  

Has anyone else seen this behavior?

Anthony

I haven't seen that, but this filter is not working quite right for me. It is not showing all tickets that a user is mentioned in. I can't figure out what's different about the tickets that are showing up compared to the ones that are missing (they're in the same project, same workflow status, same issue type, etc.). 

One thing I have noticed with this JQL is that, if the current user was mentioned in a Jira Issue months ago and the issue was updated without the currentuser mentioned in the past 7 days the JQL still returns that Jira Issue.

I am looking for a JQL that can show the issues where the current user was mentioned in comments that were made in the last 7 days. 

Hmm, interesting.  Setting aside the user mention for a moment, is it possible to query for issues that have been commented on in the last 7 days (and not updated in any other way?)  

0 votes
Joana Correia I'm New Here Tuesday

HI all, anyone knows how I could query the tickets where i was mentioned on the last comment of the ticket?

 

thanks!!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Calling all Jira Cloud users! Give us feedback on our exploration of a new navigation.

Hi everyone! My name’s Matt and I’m a product manager at Atlassian. I work in the navigation & findability space for all our Jira Cloud products. We’ve been working on trying to improve the exp...

1,051 views 16 12
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you