Automation: Custom field to have open or future sprint name to which issue is belonging currently

Question

Hello,

I have custom field Actual Sprint, where I would like to see open or future sprint name to which issue is belonging currently.

I am trying to setup automation to do this, but I am not expert.

My idea is:

when default Sprint field is changed
copy value of default Sprint field to Actual Sprint,

Unfortunately default Sprint field contains all closed sprints + open or future sprint name to which issue is belonging currently.

My team moves issues between sprints and backlog quite often, in such cases automation does not work as expected.

How do I avoid populating closed sprint names to field Actual Sprint?

Best Regards, Pjotrs

Kalyan Sattaluri_iinm1n · Answer

Great solution.

Unfortunately turns out Data center does not have the Sprint's state attribute exposed. Cloud worked of course as you demonstrated. Thanks!

Bill Sheboy · Answer

Hi @Pjotrs Obuhovs -- Welcome to the Atlassian Community!

Do you mean you want the active (or future) sprint stored in the "Actual Sprint" field, ignoring any closed ones?

If so, you may try filtering on the sprint state, and then return just the sprint id value.  For example:

How this works...

* iterate over the values in the sprint field: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-lists/#Combined-function-examples
* and using smart value, list filtering, only return the ones where the state is "active" or in the "future": https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588
* and for that one, return just the id attribute

Kind regards,
Bill