Question about JIRA Filters

[Kristen Viscardi]

I'm trying to sort CSI tickets based on MRR field value.

project = CSI AND status in ("In Progress", New, Pending, Assigned) AND issueFunction in hasLinks() ORDER By MRR ASC

But the sorting results are not the one I want.
It showed sorting like below format:
0
1
10
100
1000
2
20
200
2000
3
............

How can I sort the number base on the true value as (1, 2, 3, 10, 20,
30....)?

[Nic Brough -Adaptavist- · Accepted solution]

What type of field is MRR?  I suspect it's not a number, so the issues are being sorted alphabetically, not numerically.

[Kristen Viscardi]

MRR is a text field. Should I made it numerical?

[Kristen Viscardi]

Should we convert the field?

[Nic Brough -Adaptavist-]

Yes, changing it to a numeric will fix the order.  The other option is to prefix the shorter options with 00000