Select all issues with a confluence page linked

Sara De Cristofano July 7, 2020

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

2 answers

2 accepted

7 votes
Answer accepted
Olga Videc
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 7, 2020

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 March 2, 2022

This is great. Thanks.

Buket dülger March 11, 2024

Thank you!!

2 votes
Answer accepted
Jack Nolddor _Sweet Bananas_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
July 7, 2020

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:

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events