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
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
https://developer.atlassian.com/display/JIRADEV/Database+Schema is a better place to look - it's kept up to date by Atlassian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.