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.
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]'
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.