JQL for mentions, sorted by the mention date.

Sean Lively

I can find Jira issues where the current user is mentioned in the comment or description:

comment ~ currentUser() or description ~ currentUser()

How can I then sort the results by the updatedDate of the comment the mention was found?

I need a filter to show users what issues they are mentioned in so they can follow up if necessary.
Ordering by the issue's updatedDate is ok, but that'll cause activity they're not mentioned in to move issues to the top, causing a lot of extra review.

Trudy P Claspill

Hello @Sean Lively 

With native Jira functionality you cannot get what you want.

JQL is a tool for returning issues that match criteria. The JQL is returning the issue with the mention in the comment or description. It isn't returning the one comment specifically.

What if the user was mentioned in only in the description? How would you sort that issue in the list when the user isn't mentioned in a comment at all.

What about issues where the user is mentioned and has already followed up? Those issues are going to clog up the list and make the list longer and longer over time.

There might be a third party app in the Atlassian Marketplace that would help you. I can't recommend any specific one because I have not looked at them for a solution for this problem.

It might also be possible to work something out through Automation Rules, where you could send the user an email of the results.

The users should be getting notifications when they are mentioned, unless they have changed their personal notification settings to not receive those. Can they not use that to keep track of issues where they need to follow up?