display sprint status as Ongoing/Not-started/Finished

[emagnun]

I have my confluence table as below. How do I get to display the sprint's status as Ongoing/Not-started/Finished ? What kind of Jira query that I could use here?

[Alexey Matveev · Accepted solution]

Hello,

You need to set the Resolution field for the issues. Kindly read a similair question and the answers

https://community.atlassian.com/t5/Jira-questions/Done-issues-aren-t-shown-as-crossed-out/qaq-p/687203

[Steve Lorimer]

@Alexey Matveev thanks for the quick reply!

How do I set a resolution?

I changed the status to Done, but can't set a resolution.

[Alexey Matveev]

You need either

1. Set a screen with the resolution field for  the transition to the status Done. Then when you transition to the Done status you can choose resolution.

2. Add the Update Issue Field post function to the transition to the Done status and update there the resolution field to the required resolution.

[Steve Lorimer]

Thank you!

[Brian Janiszewski]

For those completely lost when they find this ticket like myself. See here, and watch the video: https://confluence.atlassian.com/jirakb/jira-issues-need-a-resolution-826873869.html

You have to change the properties of the transitions. I know it says it above but I wanted to be more explicit and clear.