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.
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]
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
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.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.. ;)
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot