The nodeassociation table holds the details about versions, components etc. Following is a query that works in the latest JIRA version:
SELECT concat(pr.pkey, '-',ji.issuenum) as issuekey, comp.cname FROM nodeassociation na, component comp, jiraissue ji, project pr WHERE comp.id = na.sink_node_id AND ji.id = na.source_node_id AND na.association_type = 'IssueComponent' AND pr.pkey='DEMO' AND ji.issuenum='123';
As you can see, it gets you details about components of an issue with key DEMO-123. You can similarly get version details as well.
PS: This query was taken from my book - JIRA Development Cookbook - Third Edition. You will find similar examples in Chapter 10 but hope this helps.
I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG