How to copy the Sprint Name into another field

Business Need: I need to order the issues by sprints, something which JQL (unbelievable!) does not yet support.

Workaround : I want to copy the sprint name into a calculated field. (and hopefully jql will allow me to order by this field) .

Any ideas how to do this in the simplest way possible ? Custom addins like Jira Misc Custom Fields or Script runner ?

Any help with how to configure the syntax will be greatly appreciated!

2 answers

1 accepted

This widget could not be displayed.

The formula is actually returning a Sprint object, which is then automatically converted (by Java) into a String by its toString() method.

So if you want just the name, you should call getName() on the object.

Thanks!

I've tried the following:

<!-- @@Formula: issue.get("customfield_10500").getName() -->

The error I'm geting in jira.log:

[innovalog.jmcf.fields.CalculatedTextField] CalculatedTextField: error evaluating formula: Sourced file: inline evaluation of: `` issue.get("customfield_10500").getName() ;'' : Error in method invocation: Method getName() not found in class'java.util.ArrayList'

You first need to get the first version, because fixVersion is a multi-valued field:

issue.get("customfield_10500").iterator().next().getName()

Of course, you should protect this code against errors (such as if issue.get("customfield_10500").isEmpty())

Great! that worked! and to use numerical sorting, I switch to the Calculated Number Field and changed the formula to issue.get("customfield_10500").iterator().next().getId()

and it works, big PM Headache solved, thanks David!

Thank you both for this answer - it is so simple and works!

This widget could not be displayed.

I'ved tried doing this with Misc Custom Fields addin

I'm getting:

[com.atlassian.greenhopper.service.sprint.Sprint@f39332[rapidViewId=1,state=ACTIVE,name=ITER12,startDate=2013-12-02T10:56:00.000+01:00,endDate=2013-12-20T10:56:00.000+01:00,completeDate=,id=9]]

is there any way to configure the formula to only return me the value between "name=' and ",Startdate" I could use (0,0) but i cannot say for certain what will be a standard length for all sprint names

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published Aug 06, 2018 in Agile

Boosting team's visibility with ScriptRunner like a boss

Just like almost every team here we are struggling with visibility both internal and external each day. I want to share a short story about how we have improved the internal part by a great deal and ...

350 views 0 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you