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!
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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())
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you both for this answer - it is so simple and works!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Recommended Learning For You
Level up your skills with Atlassian learning
Jira Align Program Essentials
Learn how to use Jira Align at the program level and how to plan for and manage your Program Increment (PI).
Managing Agile Boards and Reports
Learn how to pick the right board type for your team and customize it to fit your specific requirements.
Atlassian Certified Associate
Jira Software Board Configuration
Earn an associate-level credential from Atlassian that shows you can effectively configure Jira Software boards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.