Finding a field in the Jira Database

[Brian Dufort]

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.

[Gaston Valente]

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]'

[Gaston Valente]

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