Calculated Field not sorting

Sara Wortman

I created a Calculated (scripted) Number Field using JMCF called "Parent WSJF". We are using it for Features to get their parent Epic's WSJF score.

 

The Groovy formula is:

 

double parentWSJF = issue.portfolioParent.get("customfield_10234")

return parentWSJF

 

The field appears to be working properly. It is accurate in getting the WSJF score of the parent Epic.

However, in filters/searches, when trying to sort by that field, it does not show the numbers in order (asc or dec). Also, if I search for issues where "parentWSJF is EMPTY", issues that have a value for that field are displayed. 

I've toggled the Search template between Number range searcher and number range searcher (statistics-compatible), but that did not work.

 

Any ideas are appreciated!!

David Fischer

First of all, for searching and sorting to work, you need to re-index Jira, as Jira itself recommends in a message box whenever you edit a custom field.

Then, because your custom field is showing the value of a field from a different issue (here the Parent issue in the Advanced Roadmap hierarchy), you also need to configure Auto-indexing to force child issues (in the Advanced Roadmap hierarchy) to be re-indexed whenever an issue is modified. Otherwise, if the parent issue's WSJF score is modified, the index for child issues won't be updated because Jira will only update the index of the modified issue (the parent).