How do I find a list of all the issues with relations that have external links

Valentin Dragin

My goal is to query issues in the issue search that I have on the project in Jira that have external references meaning that these are the user stories my vendor has. I would like to have these relations in an excel or csv file.

So far I am able to query specific issue's ids through JQL when I know te ids exactly. 

First downside is that it is tedious to search by each external issue id. The second one is that I cannot access the vendor's Jira board because I do not have the access to it. 

Please give me a way either through the Jira's UI, JQL or Python scripting using Jira's REST API to get what I describe in the first paragraph. This would be extremely helpful. Thank you.

Valentin Dragin

It turns out that the following Jira query:

project = <project> AND "External references[Paragraph]" ~ <project> ORDER BY created DESC

gets a list of issues on the project that have any external references. This is how we reference the issues between boards with our vendor. 

The csv that I extract from Jira has a column called Custom field (External references). The outcome is not pretty but this is a good starting point. 

If you have any advice on how to enhance it the whole process, please let me know!

I hope someone will find it useful too.