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
It works! Thank you. But can I see time, when fixversion was changed?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'
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.