Originally asked by Joe Mallon on 29 September 2022 (original question)
I have a sync that works inside a single Jira instance. It syncs issues from several projects into one. Is there a way to see the ID of an issue’s replica in the results of a filter (as a column), or in the results of either a REST API call or a MySQL query?
E.g., ABC-123 is synced to REPLICA-425. How can I see “REPLICA-425” if ABC-123 is returned by a filter, or is returned in a REST API call?
Exalate’s docs recommend adding a custom field for that information, but the syncing’s already in place, so how would I know what to put in that field for existing synced issues?
Comments:
Ariel Aguilar commented on 30 September 2022
Hi Joe,
You may want to run a MySQL query as below:
SELECT LR."ISSUE_URN" AS local_issue, RR."ISSUE_URN" AS remote_issue
FROM "AO_08F1AF_TWIN_TRACE" TT
LEFT JOIN "AO_08F1AF_REPLICA" LR ON TT."LOCAL_REPLICA_ID" = LR."ID"
LEFT JOIN "AO_08F1AF_REPLICA" RR ON TT."REMOTE_REPLICA_ID" = RR."ID"
JOIN "AO_08F1AF_RELATION" R ON TT."RELATION_ID" = R."ID"
WHERE R."NAME" IN ('Connection_to_Name');
Kind regards