We use Jira and Confluence and i want to query (in Jira) wich Jira issues are mentioned in a specific Confluence page.
This query should be usefull to use for integration testing.
Thanx in advance for you're help.
I don't know of a way to do this in Jira, but in Confluence, you can open a page and see a list of issues which have been linked to that Confluence page. I know it's not a Jira query, but this can at least get you the information you're looking for.
This also worked for me, but it was not trivial to pull off, so i will explain for posterity:
issue in (issuesWithRemoteLinksByGlobalId('appId=<APP_ID>&pageId=<PAGE_ID>'))
Use that JQL to insert into Confluence page or create a custom search
You should also be able to construct this query yourself if you know the API ID (for jira integration) and Confluence page ID
Well this is timely :) I was looking for something similar whereby I want to show the "mentioned in" links in a report so that I can create a quick way to access and update the related page in Confluence. Especially useful when trying to put together reports that are easy to use for the non-Confluence fans.
I think you can do this with ScriptRunner if you have that add-on installed. I haven't tested this, but here's a link their documentation that I think covers this:
I don't think there's a way to do this without an add-on, though.
There's no way to display remote links in the issue navigator. There was an open ticket with Atlassian to implement this, but it was closed with a resolution of "won't fix" (view details here). To see the specific page the issue is mentioned in, you'd have to open each individual issue, unfortunately.
You could do the following if you are looking for specific pages you need to update:
You mention pages so wanted to check to see if you have been able to pass in a parent page to get all the JIRA tickets mention on all the child pages:
The business need is that we have a review meeting each week which we have a confluence page for. On these pages we list JIRA tickets using the JIRA widget which we need to capture a list of for all meeting pages which are children of a parent meeting master page.
I can query the JIRA tickets mentioned in one page as follows:
Based on my research so far the two options that I thought might work are:
but these don't return any results.
I have spaces around the 'in' but adding %20 doesn't work.
Another approach could be that all the meeting page titles have a subset of words we can also query on.
I hope this is possible as if we can't we have two issues:
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events