Sort by a custom field of type priorization dont work

Question

Hello everyone.

I have been assigned a bug that is occurring in the jira application. The problem is that it is failing to sort the ticket filters by a custom prioritization field. I have tried to launch a complete reindex and it has not solved the problem.

Has anyone had a similar situation happen to them?

Thank you very much for your help.

Trudy P Claspill · Answer

How is the number field being filled in? Is it filled in by users through the UI, or is it filled in by a script or by an Automation Rule?

Can you show us the ORDER BY clause for your search?

miguel_2eat46 · Answer

It is a prioritization field with a numeric value, an example of the error would be:

name  priorityCamp(cf)

ticket1 0

ticket2 5

ticket3 4

ticket3 3

...

In this case the ticket with priority 0 is put in the first position when it should be the last. I can't understand why this happens in some cf's and not in others.

ty for the help !

Trudy P Claspill · Answer

What type of field is the custom field? Is it text, or number, or select list?

Can you provide an example of values used for this field being sorted incorrectly?