It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Posted in Agile

Overview of Advanced Roadmaps UI + Get started with Automation for Jira - Demo Den September 2020

Deliver better and faster value to your customers with the Jira automation platform. Watch this Demo Den series below to learn how to use the new interface and set up automation rules to help your te...

1,281 views 3 6
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you