Order ScriprRunnner Calculated Field

Question

I have a calculated field that divides two numbers. The division works correctly and I'm able to format the number with the decimal places that I need.

The problem is when I try to order the field. It seams that it's ordering as a text and not a number. the out put that i got is 1.0 2.0 2.6 20.0 4.0 ...

The searcher is "Number Searcher" and the output is cast to Double.

Any tips on how to order this as numbers ?

Nic Brough -Adaptavist- · Answer

Ok, well, I can replicate that behaviour:

* Create custom field
* Go to SR and put the script in, changing the template to numeric
* Create a load of issues that exhibit the failure to sort
* Remember that I have not changed the searcher, and go do that, selecting "number range"

Still got the text-like sort

To fix it: re-index after changing the searcher!

(I forgot - we did have a bug in SR 5.something that broke number searches for a while, but I tested with Jira 8.20 and SR 6.48, and it all worked.  I think we should check versions)

Pedro Felgueiras · Answer

We are using "Number Field" as the template

Nic Brough -Adaptavist- · Answer

What template did you use in the scripted field settings?  (Not the search, that looks right, but the template in the scripted field settings themselves)