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.
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
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