Need to find number of issues for a given version id through DB.?

[ramesh_babu NA]

Hi  Guys ,

  I looked at DB level to get the number of issues for a given versionID. I know jiraIssue.id had 1to n relationship with PROJECTVERSION.id. CAn anyone point me the Table name where they maintain this relation.

Thanks

Ramesh

[ramesh_babu NA]

got the answer from 

http://doc.go2group.com/download/attachments/5931033/DbSchema.pdf?api=v2

select ji.pkey, pv.vname from jiraissue ji, projectversion pv, nodeassociation na where na.source_node_entity = 'Issue' and na.sink_node_entity = 'Version' and na.source_node_id = ji.id and na.association_type = 'IssueFixVersion' and pv.id = na.sink_node_id

select ji.pkey, pv.vname from jiraissue ji, projectversion pv, nodeassociation na where na.source_node_entity = 'Issue' and na.sink_node_entity = 'Version' and na.source_node_id = ji.id and na.association_type = 'IssueVersion' and pv.id = na.sink_node_id

--Thanks

[Nic Brough -Adaptavist-]

https://developer.atlassian.com/display/JIRADEV/Database+Schema is a better place to look - it's kept up to date by Atlassian

[ramesh_babu NA]

Thanks Nic