nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Nic Brough -Adaptavist-

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.

All comments

Nic Brough -Adaptavist-

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.

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

Uta Zimmermann

Thank you very much..

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira