Filter by Issue Links "mentioned in"

Is it possible with a jql query to filter issues by Issue Links "mentioned in" ?
The "mentioned in" issue links are automatically created when issues are inserted in a confluence page :

For instance, I want to filter in Jira all the issues mentioned in the same confluence page.

6 answers

1 accepted

1 vote

You can use the JQL Tricks Plugin (commercial) to do this. See hasRemoteLinks function.

If you want to search for issues with specific page link, use the last example.

Hi Jobin,
Thanks for your reply. Is there another (non-commercial) solution ?

This Plugin don't support "mentioned in". issue in hasLinks("mentioned in") Could not find any issue link type having either inward or outward description: mentioned in. Available links are: [adds, is added by, changes, is changed by, cloned from, cloned to, blocks, depends on, duplicates, is duplicated by, is Epic of, has Epic, introduces, is introduced by, could prevent, could be prevented by, removes, is removed by, requests, is requested by]

agree with @Konstantin Desyatkov, This plugins can search for issues by "link name" such as cloned to, blocks, and it can search for issues by remote link when linking to a URL, but "mentioned in" belong to either of the two situations.

but "mentioned in" belong to neither of the two situations.

Atlassian hasn't bothered to implement a way to search for @mentions directly using JQL.

Plugins however tend to be expensive and cause problems during upgrades.

The workaround most people seem to use is to JQL-query for issues containing the name of the user in comments or text. Not ideal, but better than nothing, or having to spend money again just because Atlassian decided not to implement a feature.

Like this one: "Issues the user was mentioned in last week", I think you can leave out the "summary" part.

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

Another recent solution and probably more accessible for common users is Impact for JIRA (, which allows to display issues with confluence links in a tree view. 



I tried to search issues mentioned in Confluence with Script Runner which own rich and useful JQL functions.  May be @Jamie Echlin (Adaptavist) knows that  is there any possible to search for the issues has "mentioned in"link type,because "mentioned in" a confluence page belongs to neither any link type name nor  remote link to a URL, so I cannot use haslinktype or linkedIssuesOfRemote to find out what I need. thanks

I needed also has a list with issues from a Fix version which contains at least one confluence document. The only way I found is to make a Query in Confluence (with Pocket Query plugin) pointing to Jira database, something like this (my database is Oracle): 

SELECT project.pkey||'-'||jiraissue.issuenum idjira,, projectversion.vname, remotelink.url
FROM projectversion,
WHERE nodeassociation.ASSOCIATION_TYPE = 'IssueFixVersion'
AND nodeassociation.SINK_NODE_ID =
AND nodeassociation.SOURCE_NODE_ID =
and projectversion.vname in (:Version)
AND remotelink.title in ('Page','Wiki Page') 

Hope it helps.. ;)

I had similar problem: creating a JQL query to select all the issues mentioned in some text block. To solve it I made a simple JavaScript application:

Suggest an answer

Log in or Join to answer
Community showcase
Louis De Jaeger
Posted 6 hours ago in Off-topic

Friday fun: your best joke

Hi all Lets make this Friday fun really fun and post one (or more) of your best jokes! The joke can be about an Atlassian product, or just a really fun joke you want to share! I’m not the best j...

23 views 1 2
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot