Fetch fields of linked issues in search

[Sebastian Kern]

Hello,

I have an issue A, linked to an issue B (1:1 relationship).

Now I am performing a search for issue A.

Is there a way (or probably workaround) to include columns from B (like B.status, B.edited) in the resultset?

Thanks

Sebastian

[Walter Buggenhout · Accepted solution]

Hi @Sebastian Kern and welcome to the Community,

No, unfortunately not. Unlike SQL queries that you execute directly on a database and allows you to define JOIN relationships, JQL in the Jira UI always retrieves a list of issues with attributes of those issues only.

By adding the linked issues column to your result set, looking up the related values is just one click away. But if you need to look at an extensive list of issues, workarounds may vary based on your use case.

If this is a one time (or very occasional) event, you could export your data and match the result sets in e.g Excel. If you have integrated processes (e.g. a service desk ticket that results in a linked bug and you would like to see the expected release date of the fix that is reported on the bug ticket), you could consider syncing the value of key custom fields between tickets. That's something you could do with Automation.

Hope this helps!

[Sebastian Kern]

Thanks!