How to see issue fixversion full history

Pavel Gromov April 13, 2015

Hello! I need to see issue fixversion full history by using SQL query. How can I do this?

2 answers

1 accepted

1 vote
Answer accepted
Paula Silveira
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 13, 2015

Hi Pavel,

I think you can try the following: 

select * 
from changeitem 
where groupid in 
(select id from changegroup where issueid = (select id from jiraissue where issuenum = <your issue> and project = (select id from project where pkey= <your project>)))
and field = 'Fix Version';

Thanks and regards,
Paula Silveira 

Pavel Gromov April 13, 2015

It works! Thank you. But can I see time, when fixversion was changed?

Pavel Gromov April 13, 2015

I think, I got it. select cg.created, ci.* from changeitem ci inner join changegroup cg on ci.groupid = cg.ID where groupid in (select id from changegroup where issueid = (select id from jiraissue where issuenum = 52738 and project = (select id from project where pkey= 'AC'))) and field = 'Fix Version';

0 votes
Pablo Beltran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 24, 2015

It is also achievable with the SQL for JIRA plugin:

 

select
     *
from
     issuechanges c
where
    c.issueid=<your issue id>
	and
	c.field = 'Fix Version'

Suggest an answer

Log in or Sign up to answer