Questions for Confluence license has expired.

Please purchase a new license to continue using Questions for Confluence.

Show synced issue ID in filter or REST API call

 
1
0
-1

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?

  1. Ariel Aguilar

    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

CommentAdd your comment...