Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,370,110
Community Members
 
Community Events
168
Community Groups

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

1 vote
Answer accepted

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!

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
TAGS

Atlassian Community Events