Jira PKEY history

[Uta Zimmermann]

Hi,

when I change the project from a jiraissue, the pkey (project.pkey + jiraissue.issuenum) change. How can I find the old pkey, how is the relation between the old and the new pkey? When I put the old pkey in the searching-field, jira find it and shows me the new, so there have to be a relation in the database..

Thanks for help,

Uta

[Nic Brough -Adaptavist- · Accepted solution]

There's a table called moved_issue

The fact you're asking though worries me, as you should never be trying to use a Jira database directly, even for just reporting.  It will hurt you.

[Uta Zimmermann]

Thank you very much..

[Marcos PS [DEISER]]

Hello Uta,

As you said, the relation is stored in the DB, being more concrete, in the table project_key, there you can find all the current and previous project keys associated to the project ids.

If you need to make this information accessible thru a Jira custom field you have to use 3rd party addons able to create new custom fields and populate them with DB query results like nFeed (pay) or PowerCustomFields (free)... and sure you can find some more.

Additionally, please, take a look to this documentation in order to understand better what a pkey change involves.

Best regards,

Marcos.

[Marcos PS [DEISER]]

mmm... I see you moved the issue not changed the pkey... I read what I wanted to read!.

Nic's answer have sense :)