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-

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