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")
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!!
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).
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
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