FixVersion is not sorting

[J]

I ran a query " text ~ matching ORDER BY FixVersion ASC". The results returned is not sorted by FixVersion. Any idea why? 

[Krishnanand Nayak]

here is the solution : https://confluence.atlassian.com/jirakb/sort-fix-version-s-into-a-correct-order-on-the-issue-search-result-950290183.html

In case you have more that 10 records to fix, work with your system admin to run a update sql to update the sequence. Please make sure that the JIRA instance is down before you run any insert/update SQL or it can corrupt your instance. Also test your sql on your Test instance first. 

[Vinu]

Hi @J

Tried to replicate a similar scenario and order by fixversion does work for me fora  similar query as yours. Can you get us some more information?

May be there are chances you missed to notice the order due to the absence of various fix version?

Can you please check those parameters and let us know and it will be easier to troubleshoot?

[J]

The query is below...

project = product request AND text ~ matching ORDER BY FixedVersion ASC 

The first 27 records were sorted correctly then it goes out of order after that.