ISSUEMOVED |
|
| ||
Column | OLDKEY | ISSUEID | ||
Type | VARCHAººRVARCHAR | BIGINT | ||
Indexed | | x |
It gets allows to query the new issue id for a given old issue key.
The table is not populated by default:
SELECT * from issuemoved
will return nothing unless an old issue key is provided.
Example: How to find the new issue key?
SELECT m.oldkey, i.key
FROM issuemoved m INNER JOIN issues i ON i.id = m.issueid
WHERE m.oldkey='MYPROJ-1'that an issue has been moved to. Note that is not possible to query the opposite: has this issue moved from? as the Jira API does not support it.