nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to see issue fixversion full history

PaGrom

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

Accepted answers

Paula Silveira

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 = &lt;your issue&gt; and project = (select id from project where pkey= &lt;your project&gt;)))
and field = 'Fix Version';

Thanks and regards,
Paula Silveira

All comments

Paula Silveira

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 = &lt;your issue&gt; and project = (select id from project where pkey= &lt;your project&gt;)))
and field = 'Fix Version';

Thanks and regards,
Paula Silveira

PaGrom

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

PaGrom

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';

Contact Kintosoft

It is also achievable with the SQL for JIRA plugin:

select
     *
from
     issuechanges c
where
    c.issueid=&lt;your issue id&gt;
	and
	c.field = 'Fix Version'

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

sql

jira

jira-administration

ms-sql