Select all issues with a confluence page linked

[Sara De Cristofano]

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 solution]

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

[ViswanathanR]

This is great. Thanks.

[Buket dülger]

Thank you!!

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

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

remoteLinkedIssuesOf("application", "confluence")

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

References:

• Official documentation