JQL find ticket with issue links "mentioned in" (means confluence)

Question

I would like to filter all my tickets the following:

Ticket have under "Issue links" the subategory/used  "mentioned in"

Search all tickets which are "mentioned in" in a confluence site

The link of the confluence site is autmatic integrated at the jira ticket.

Roger_mko8im · Answer

Thanks for the feedback. Sad that this kind of analyse is not possible without additionals

mauricio.groth · Answer

Hi @Roger

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your issues that contain the remote link to an application like Confluence.

remoteLinkApplicationName="Confluence"

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

Barnali Putatunda_lza0ju · Answer

Hello,

Jira by default does not provide that much flexibility for searching based on different link types. However, there are apps in marketplace that can help you create JQLs like this.

As an example, Scriptrunner offers a JQL function "linkedIssuesOfRemote" which could help to get the desired result as per your need.
Find all issues linked to a linked Confluence instance:
issueFunction in linkedIssuesOfRemote("application name", "Confluence")

You may get more details here: https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/issue-links