Finding a field in the Jira Database

Brian Dufort July 21, 2017

We're on version 7.3.7.  I'm trying to locate the database table that has a particular field (Component).  My ultimate goal is to: find all the jira issues which have zzz Component.  I don't see it in the jiraissue table.  Any help would be appreciated.

2 answers

0 votes
Gaston Valente
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 21, 2017

The query you need i think:


SELECT i.* FROM jiraissue i
INNER JOIN nodeassociation na ON na.source_node_id = i.id
INNER JOIN component c ON na.sink_node_id = c.id
WHERE c.id = '[component id]'

0 votes
Gaston Valente
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 21, 2017

This is the table, called "component"



CREATE TABLE JIRA7.jiraschema.component (
ID numeric(18,0) NOT NULL,
PROJECT numeric(18,0),
cname nvarchar(255),
description ntext,
URL nvarchar(255),
LEAD nvarchar(255),
ASSIGNEETYPE numeric(18,0),
CONSTRAINT PK_component PRIMARY KEY (ID)
) go

Suggest an answer

Log in or Sign up to answer