Sometimes we just have to dig through the Jira Server or Datacenter database to find what we’re looking for. In this case, we want to know the old references of the moved tickets and extract a list. How do we do it? We will query the database as there is no other way through the Jira REST API. Let’s see how it’s done:

SELECT concat(project.pkey, '-', jiraissue.issuenum) as KEY,
moved_issue_key.old_issue_key as OLD
WHERE = jiraissue.project 
and = moved_issue_key.issue_id

You have to consult the table moved_issue_key

More public examples:

By MrAddon


Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s