looking for "Team Target Completion Sprints" field data in DB

[nitin raghav]

We’re trying to identify the corresponding column in the database for the Jira Align field ‘Team Target Completion Sprints’, marked in green in Snapshot.

The closest match we found is the ‘Date Team Target Completion’ column in the ‘Feature Team Sprint’ table.

 Is this the correct field that maps to ‘Team Target Completion Sprints’?

[Sam Tsubota · Accepted solution]

@nitin raghav In Enterprise Insights, there is a table [Feature Team Sprint] that has this data. There is a column [FK Anchor Sprint Target ID] that you will join to the [Anchor Sprint ID] column in the [Anchor Sprint] table to return the [Anchor Sprint Name]. In your query, you need to filter the records in the [Feature Team Sprint] table where the [Current Record Flag] = Yes. 

[nitin raghav]

Thanks for the info, @Sam Tsubota. Could you clarify which column contains this data?

I just want to confirm that the ‘Date Team Target Completion’ column in the ‘Feature Team Sprint’ table is the correct one to refer to."

[nitin raghav]

.