sql query to retrieve all component in jira database

Fidelidade JIRA Admin

Hello, Good Day

Can someone help me?

I would like to get the list of all created components that are in Jira's database.

Thank you

Niranjan

Hi @Fidelidade JIRA Admin ,

The query should give all compoents in JIRA

Select * from component ;

 

Quoting another SQL from here

SELECT count(ji.id), c.cname FROM jiraissue ji 
INNER JOIN nodeassociation na ON ji.id = na.source_node_id
INNER JOIN component c ON na.sink_node_id = c.id
GROUP BY c.cname