How to get the component, severity, releases and priority of the bug from jiradb?

[Vimal Annamalai]

I want to know component, Releases and priority of the bug.

[Moga]

Hi Vimal,

For this example, let's say the JIRA issue key is TEST-1. 

For the following SQL, you will need to replace p.pkey and ji.issuenum with your issue key.

Component: 

SELECT
  p.pkey||'-'||ji.issuenum as Issue, c.cname
FROM jiraissue ji
JOIN project p
  ON p.id = ji.project
JOIN nodeassociation na
  ON ji.id = na.source_node_id
JOIN component c
  ON na.sink_node_id = c.id
  AND p.pkey = 'TEST'
  AND ji.issuenum = 1;

Priority: 

SELECT
  p.pkey||'-'||ji.issuenum as Issue, pt.pname
FROM jiraissue ji
JOIN project p
  ON p.id = ji.project
JOIN priority pt
  ON pt.id = ji.priority
  AND p.pkey = 'TEST'
  AND ji.issuenum = 1;

Release: JIRA issue does not have Release field. Can you please be more specific here?

I hope that this helps.

Cheers,
Moga