Filter by Issue Links "mentioned in"

Kevin Le Ner January 8, 2014

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.

7 answers

1 accepted

2 votes
Answer accepted
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 8, 2014

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

http://www.j-tricks.com/jqlt-links-functions.html

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

Kevin Le Ner January 9, 2014

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

kdesyatkov August 26, 2015

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]

Like Martin Dahlborg likes this
hote April 24, 2016

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.

hote April 24, 2016

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

4 votes
David Skreiner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 18, 2016

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 

Jacus_de_Beer October 1, 2018

A shortcut for the series of ORs is:

text ~ currentUser()

Which will find all references to the current user in any text fields (including summary, description, and comments)

See: https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html#Advancedsearching-fieldsreference-textTextText

Like # people like this
dezren39 March 25, 2021

thank you

2 votes
Marco Weist June 29, 2018

I had the same issue. I wanted to create a JQL query to show me all stories which are linked within a certain confluence page. 

It is possible to create that query. As mentioned somewhere else it is possible to see a counter for the linked issues directly in Confluence. This counter gives the option to show a list of these tickets in Jira in the issue filter view. 

To do that it applies a JQL query such as
"issue in (issuesWithRemoteLinksByGlobalId('...),...)"

Just copy and paste the query and replace "in" with "not in" or whatever is desired.  

Damián Sánchez Moreno March 26, 2019

This is the right answer.

Penelope Hobbs April 16, 2020

This is the right answer and here's another thread with details for using the query: https://community.atlassian.com/t5/Jira-questions/How-to-list-the-globalId-to-use-in/qaq-p/177062

1 vote
vvzh August 7, 2017

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: https://github.com/vvzh/jiralinker

1 vote
Aitor Morant June 14, 2017

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.id, projectversion.vname, remotelink.url
FROM projectversion,
nodeassociation,
jiraissue,
remotelink,
project
WHERE nodeassociation.ASSOCIATION_TYPE = 'IssueFixVersion'
AND nodeassociation.SINK_NODE_ID = projectversion.id
AND nodeassociation.SOURCE_NODE_ID = jiraissue.id
and projectversion.vname in (:Version)
AND remotelink.title in ('Page','Wiki Page') 
AND remotelink.issueid=jiraissue.id
and project.id=jiraissue.project; 

Hope it helps.. ;)

1 vote
hote April 24, 2016

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

0 votes
LUC FILION December 16, 2014

Another recent solution and probably more accessible for common users is Impact for JIRA (http://bit.ly/1tYPzxu), which allows to display issues with confluence links in a tree view. 

Cheers,

Luc

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events