Using SQL to show component in Worklog

John-S Pretorius

Good day, I'm a newby @ Jira

We have read access to Jira tables and generate our own reports locally. I'm looking to have a SQL query that will show the component value with worklog by means of joining tables. I'm fully aware of the timesheets and other modules but are really interested in how to join the mentioned tables.

 

Much appreciated

John-S Pretorius

I did some more digging and came across a September 04 post From Arthur Goncalves doing the same for jirissue and component - see below

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

By tweaking the original query and adding some additional fields I was able to get the desired results.

This is resolved, thanks to Arthur Goncalves.