{"id":1094,"date":"2014-01-21T14:34:38","date_gmt":"2014-01-21T13:34:38","guid":{"rendered":"http:\/\/www.capri-soft.de\/blog\/?p=1094"},"modified":"2014-01-21T14:34:38","modified_gmt":"2014-01-21T13:34:38","slug":"jira-6-1-and-above-database-field-pkey-is-empty","status":"publish","type":"post","link":"https:\/\/www.capri-soft.de\/blog\/?p=1094","title":{"rendered":"JIRA 6.1. and above: Database field PKEY is empty"},"content":{"rendered":"

Problem<\/h1>\n

In prior versions than JIRA 6.1., the table „jiraissue“ in the database has stored the Issue IDs and has made it possible to make a selection on Issue IDs. Unfortunalety this field is empty now. It is not possible to select values because of the Issue ID.<\/p>\n

Approach<\/h1>\n

Analysing the table shows a new column name „issuenum“ which can be used in combination with the colum „project“ to concatenate the Issue Key.<\/p>\n

Solution<\/h1>\n

SELECT project_key.PROJECT_KEY+‘-‚+CAST(issuenum AS VARCHAR(5)) as pkey, jiraissue.*
\nFROM jiraissue
\nINNER JOIN project_key
\nON jiraissue.PROJECT=project_key.PROJECT_ID
\nWHERE project_key.PROJECT_KEY+‘-‚+CAST(issuenum AS VARCHAR(5))=’VVTT-65‘<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n