How to join sprint, jira sprint, and anchor sprint in AA or SQL

[Mary Heather Cox]

Background: We sync our Jira Cloud instance with Jira Align.  Sprint sync is the bane of my existence!

Scenario: Multiple Jira Sprints are Mapped to single Jira Align Team Sprint.

I am trying to identify why we get that error, when it appears everything is in order.

So, I'm trying to join 3 tables: Jira Sprint, Sprint, and Anchor Sprint but I feel like I'm missing a FK or any ability to join Jira Sprint to Anchor Sprint or Sprint.

I am trying to get the start/end dates of the sprints in the 3 different tables to compare them. Even then, if I join Anchor Sprint and Sprint on FK_Sprint_ID and Anchor_Sprint_ID I've already ruled out the ones that don't join and those are the ones.

[Tejaswi G · Accepted solution]

Hi @Mary Heather Cox

This is Tejaswi from the Support Team and happy to help. 

Can you please log a ticket with us to check your instance and assist you further with this request? 

You can log a ticket by going to https://support.atlassian.com/contact. 

Regards,
Tejaswi