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

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.

[Oriol Ortiz]

Hi Valentin, 

I've tried this solution in our Jira Instance and seems that it's not working as expected.

My idea would be to have listed all stories that have or not have at least one test cases (in TestRail) linked to the story.

I used this filter in JQL: project = "Guest Stays Experience" AND "External references[Paragraph]" ~ "Guest Stays Experience" ORDER BY created DESC

and I'm getting the following error:

Our Jira is displayed like below

Do you know how could we do it?

[Karen Espolon]

Hi @Oriol Ortiz & @Valentin Dragin ,

May I know if you've found a viable solution to this problem? I'm planning to create a ticket regarding this to TestRail support. It'll be good if you can raise similar issue with Testrail support so they'll know that the number of people in different company are in need of this functionality. 

Thank you