nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Date from the latest sprint from an issue

Bartlomiej Bukowski

Hi,

I am wondering how I can get endDate from the newest spring assigned to the issue?

I have an automation which updates Issue `Due date` when new sprint is added to the issue.

{{issue.Sprint.endDate.minusDays(1).jiradate}}

Problem is that issue can have more than one sprint and that smart value return endDate from the oldest Sprint.

Accepted answers

Bill Sheboy

Hi @Bartlomiej Bukowski

Until a sort option/function is added to lists, we cannot rely upon first and last for a scenario like yours. (The exception is when you do have a sort, ORDER BY, for things like lookup issues with JQL.)

For your scenario, let's assume your newest sprint is the one which ends the latest. If that is the case, you can use this:

{{issue.Sprint.endDate.max}}

If that does not work for some reason, there is a much more elaborate work-around, using a REST API call and smart value, list filtering. Hopefully you will not need that one :^)

Kind regards,
Bill

All comments

Jack Brickey

Hi @Bartlomiej Bukowski , try using the "last" function.

Bartlomiej Bukowski

Hi Jack,

I tried both

{{issue.Sprint.last.endDate.minusDays(1).jiradate}}
and

It will give different date but not from the current sprint.

Example:
- Issue has already Sprint1 and Sprint2 set up
- Adding Sprint3
- DueDate set on issue changes to the date from Sprint2 and not from Sprint3.

Old smart value which is

{{issue.Sprint.endDate.minusDays(1).jiradate}}
will set up DueDate from Sprint1

There is a progress but it's not the solution yet.

Bill Sheboy

Hi @Bartlomiej Bukowski

For your scenario, let's assume your newest sprint is the one which ends the latest. If that is the case, you can use this:

{{issue.Sprint.endDate.max}}

If that does not work for some reason, there is a much more elaborate work-around, using a REST API call and smart value, list filtering. Hopefully you will not need that one :^)

Kind regards,
Bill

Bartlomiej Bukowski

Hi Bill,

Thank you for your support.
Your suggestion solved my issue.

Smart values used by me:
- for start date:
{{issue.Sprint.startDate.max.jiradate}
-for end date:
{{issue.Sprint.endDate.max.minusDays(1).jiradate}}

Best regards,
Bart

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud