Order by Aha Rank not working in Jira despite the right JQL

[Almas Fidai]

In one of our projects, we created a custom field called Aha Rank. This rank gets auto populated from the tool Aha!

When we try to order our backlog using this field, it does not work. 

Even though we are using the right JQL: 

project = CPS ORDER BY "Aha! Rank" ASC

 Please suggest what could be going wrong over here? 

[Nic Brough -Adaptavist-]

Could you tell us what type of field the "Aha! Rank" is shown as in the list of custom fields, and explain what is wrong with the ordering?   "It does not work" does not give us any information

[Almas Fidai]

Hi Nic

Thanks for your reply. Aha rank is 'text field (single line)' type. 

So, when trying to search issues based on aha ranking with the JQL mentioned above, the issues appear randomly and not in an ascending order of aha rank as it should be. 

To be more specific, the JQL is this: 

project = "xyz" and component = abc ORDER BY "Aha Rank" ASC

[Nic Brough -Adaptavist-]

I don't think this is going to be a "random" order, I think you'll find it's alphabetic.  And I'd guess your Aha rank data is probably not intended to be seen as alpha.