How to find all issues that have remote issue deleted?

 
2
1
0

Hi all,

I need to find an automatic way (either JQL, script or a database query) to find all issues that the remote issues of them are deleted (manually it looks in the sync panel like "remote issue removed").

Thanks.

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      As a short answer - you can lookup all these issues in the database using following sql query


      The exact query depends on the underlying database, this example is for postgres (and jira)

      select "ISSUE_URN" 
from "AO_08F1AF_REPLICA" re 
inner join "AO_08F1AF_TWIN_TRACE" tt on tt."LOCAL_REPLICA_ID" = re."ID" 
where tt."STATUS" = 'REMOTE_ISSUE_DELETED';

      Note - the layout of the data columns and semantics can differ from version to version of Exalate.


      Other approaches (JQL, script and so on) will need product changes

      1. Yaakov Shamii

        Thanks Francis!

      CommentAdd your comment...