Questions for Confluence license has expired.

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

Mapping file without cleaning up the connection

 
1
0
-1

Is it possible to retrieve mapping.csv file without running the "clean-up by connection"?


    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      You can extract this data by running the beolw SQL query in your DB.
      (insert the connection name instead of 'MY NICE CONNECTION NAME'):


      SELECT LR."ISSUE_URN" AS this_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 ('MY NICE CONNECTION NAME');
        CommentAdd your comment...