Select all issues with a confluence page linked

Question

Hi,

for some of my issues in Jira I have linked a Confluence page with the "Link Confluence page" functionality. Now I would like to see this info in the "Advanced search" as a column, or extract it with a JQL query. I need this info for report.

Could anyone point me in the right direction?

Thanks,

Sara

Olga Videc · Accepted Answer

Hello @Sara De Cristofano

To achieve this you need ScrriptRunner for its JQL functions

But you can use the trial version to see if it fits your needs, no limitation on trial.

After you installed ScriptRunner go to issue navigator switch to advanced and use this function

issueFunction in linkedIssuesOfRemote(host, "your confluence link")

Example

issueFunction in linkedIssuesOfRemote(host, confluence.test.cc)

Also, you can search for a specific page

issueFunction in linkedIssuesOfRemote("query", "pageId=11469162"

Full documentation here

https://scriptrunner.adaptavist.com/5.5.8/jira/jql-functions.html

BR, Olga

Jack Nolddor [Sweet Bananas] · Accepted Answer

Hi Sara,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack if you are on Server / DataCenter, you can type the following:

1) Select all issues with a confluence page linked

, "confluence")remoteLinkedIssuesOf("application"

(*) Note that this is just an example, you must tune above query to fit your needs.

References:

* Official documentation