...
Simply, extract the custom fields value from the issue obects (third column) by using the CF() function:
| Code Block |
|---|
|
select
key(Issue) as "Issue",
cf(Issue, "Sprint Id") as "Sprint",
cf(Issue, "Story Points Id") as "Story Points"
from
(select
cfd1.id as "Sprint Id",
cfd2.id as "Story Points Id"
from
issuecustomfielddefinitions cfd1
join
issuecustomfielddefinitions cfd2
where
cfd1.name = 'Sprint'
and
cfd2.name = 'Story Points')
join
(select
issue
from
JQL
where
JQL.query = 'project = SSP'
) |
| Issue | Sprint | Story Points |
|---|
| SSP-23 | Sample Sprint 1 | 2.0 |
| SSP-22 | Sample Sprint 1 | 2.0 |
| SSP-21 | Sample Sprint 1 | 1.0 |
| SSP-20 | Sample Sprint 1 | 3.0 |
| SSP-19 | Sample Sprint 1 | 5.0 |
| SSP-18 | Sample Sprint 1 | 3.0 |
| SSP-17 | Sample Sprint 2 | null |
| SSP-16 | Sample Sprint 2, Sample Sprint 1 | 2.0 |
| SSP-15 | Sample Sprint 2 | 4.0 |
| SSP-14 | Sample Sprint 2 | 3.0 |
| SSP-13 | Sample Sprint 2 | null |
| SSP-12 | Sample Sprint 2 | null |
| SSP-11 | Sample Sprint 2 | null |
| SSP-10 | Sample Sprint 2 | 5.0 |
| SSP-9 | null | 3.0 |
| SSP-8 | null | null |
| SSP-7 | null | null |
| SSP-6 | null | 1.0 |
| SSP-5 | null | 1.0 |
| SSP-4 | null | 5.0 |
| SSP-3 | null | 5.0 |
| SSP-2 | null | 2.0 |
| SSP-1 | null | 2.0 |