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....)?
What type of field is MRR? I suspect it's not a number, so the issues are being sorted alphabetically, not numerically.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, changing it to a numeric will fix the order. The other option is to prefix the shorter options with 00000
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.