How can I see a list of all connected issues?

General Questions
,
1

Originally asked by Brian Awalt on 20 May 2020 (original question)

When using Exalate with Jira Cloud where can I see a list of connected issues?Source: Jira Cloud (old community)

Comments:

Antonio de la Peña commented on 01 August 2020

I need to know this too

2

Answer by Kelly Strand on 31 March 2021

Ariel Aguilar Is there an SQL that can be used for Jira server?

3

Answer by Ariel Aguilar on 24 March 2021

Hi there,

Unfortunately, there is not an automatic way for you to pull out issues in sync but here is an SQL query which you can use:

SELECT LR.issue_urn AS this_issue, RR.issue_urn AS remote_issue FROM twin_trace TT LEFT JOIN replica LR ON TT.local_replica_id = LR.id LEFT JOIN replica RR ON TT.remote_replica_id = RR.id JOIN relation R ON TT.relation_id = R.id WHERE R.name IN ('JIRA_SERVER_to_JIRA_CLOUD');

We are looking forward on implementing this feature, but I hope you find this is helpful in the meantime.

Thanks,

Ariel