Confluence Jira Issue/Filter Display Options

[Mark Jeffery]

We have a Confluence page that contains related Jira tickets and we want to display the Sprint the Jira tickets are associated to. We are using the Jira Issue/Filter Display and searching for the Key to display the Jira ticket number. We then want to display the latest Sprint so selecting the Display Options and in Columns to display typing Sprint to display this field.

Unfortunately we displaying all the Sprints associated to the Jira ticket and we only want to display the last Sprint.

Is there anyway to simply display the current Sprint associated to the Jira ticket and not all Sprints?

[Sebastian Krzewiński]

Hi @Mark Jeffery 

Please take a look on this JQL functions:

- futureSprints() - https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-futureSprintsfutureSprints--
- openSprints() - https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-openSprintsopenSprints--
- closedSprints() - https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-closedSprintsclosedSprints--

This should help you to filter out correct issues.

Regards,

Seba