Identified in Release custom field values from JIRA

K. Praveen Kumar Reddy

I want to extract information of "Identified In Release"
for all the defects and support requests I have in my Jira datastore.

 

I have drilled down till this point:

with cte as 
(
select ji.id, ji.issuenum,pk.PROJECT_KEY,cast(ci.NEWSTRING as Nvarchar) IdentifiedInRelease,ci.ID as val
from 
jiraissue ji (NOLOCK)
left join changegroup cg (NOLOCK) on cg.issueid = ji.id
left join changeitem ci (NOLOCK) on ci.groupid = cg.id
left join project_key pk (nolock) on ji.PROJECT=pk.PROJECT_ID
left join Issuestatus IST (nolock) on IST.ID=JI.ISSUESTATUS 
where ci.FIELD like '%Identified in Release%' 
),
Maxdata as
(
select id,issuenum,max(val) as maxid,PROJECT_KEY from cte group by id,issuenum,PROJECT_KEY
)
select distinct c.ID,c.issuenum,c.IdentifiedInRelease,c.PROJECT_KEY
from 
cte c
left join Maxdata md on c.ID=md.ID and c.val=md.maxid where maxid is not null

However this is not completely capturing the custom field of Identified in Release column values fully.

Appreciate your efforts to get this corrected.
Thanks in advance.

Best,
K.Praveen Kumar Reddy

Rene C. [Atlassian Support]

Hi! When you mention that it is not completely capturing the custom field values, do you mean that something is not being shown?

Also, for more context, what kind of custom field is 'Identified in Release'? Some fields might have nested values that require some tweaking in your script.