How Can I Find Out the Number of Issues Associated With a Sprint?

Question

How can I find out the number of issues associated with a sprint?

Environment

Connector: Jira

Answer

To determine the number of issues associated with a sprint, you must join the ISSUE, ISSUE_MULTISELECT_HISTORY, SPRINT, and FIELD tables. You can use the following query:

select i.id, i.key, s.* from `jira.issue` i
inner join `jira.issue_multiselect_history` h on h.issue_id = i.id
inner join `jira.sprint` s on h.value = CAST(s.id as STRING)
inner join `jira.field` f on h.field_id = f.id
where f.name = 'Sprint' and h.is_active