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