Originally asked by Mariia Horbatiuk on 08 February 2021 (original question)
Is it possible to retrieve mapping.csv file without running the “clean-up by connection”?
Answer by Mariia Horbatiuk on 08 February 2021
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');
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.