How to capture the Team Target Completion Sprints on Jira Align Enterprise Insights
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
In the Program Board, Features can have Team Target Completion Sprints associated with them, which will make the Feature in question be moved to the sprint column. The problem is that it is not possible to export this data, or to access it through API.
Environment
Jira Align
Solution
It is possible to capture this data using Enterprise Insights, as the table [Feature Team Sprint] has this.
One possible query to capture all the details for this is:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
select
fts.[Feature Team Sprint ID],
fts.[Date Team Target Completion],
fts.[FK Feature ID],
fts.[FK Team ID],
t.[team name],
asp.[Anchor Sprint ID],
asp.[Anchor Short Name],
asp.[Date Anchor Start],
asp.[Date Anchor End],
pi.[program increment id],
pi.[pi name],
fts.[Current Record Flag]
from current_dw.[Feature Team Sprint] fts
inner join current_dw.team t on fts.[FK Team ID] = t.[Team ID]
inner join current_dw.[Anchor Sprint] asp on fts.[FK Anchor Sprint Target ID] = asp.[Anchor Sprint ID]
inner join current_dw.[Program Increment] pi on asp.[FK Program Increment ID] = pi.[Program Increment ID]
where fts.[fk feature id] in ('10418')
and fts.[Current Record Flag] in ('YES')
order by t.[team name], fts.[Current Record Flag];Where you just need to adjust the [fk feature id] to the Feature you want to see.
Was this helpful?