Sorting by a custom field with my requirements

Question

I have a custom field that I am sorting by in my filter which contains text. The issue is the filter is sorting by alphabetical order and not by criteria I would like. Is there a way to add an additional criteria to JQL? filtering for a custom ranking and its text based fill in field

Jack Brickey · Answer

So why not use a Single select field rather than a text field? This will ensure that the user doesn't mistype your priority ratings. The bottom line is a text field is simply not going to yield good results for sorting to meet your requirements.

Clara Novalis · Answer

The text field uses priority ratings very high, high, medium,low, very low. I do have a filter that I want to sort on that custom field.

Jack Brickey · Answer

Hi Clara, sorry I'm still not understanding here. Let's take the following example...

Here is some text in my text field.

Today I went swimming before work.

I have a new puppy ani I named her Pepper.

Now I want to sort this field. What criteria would I sort by other than alphabetical or reverse-alphabetical?

Is it possible that you are wanting to "filter" rather than "sort"?