I ran a query " text ~ matching ORDER BY FixVersion ASC". The results returned is not sorted by FixVersion. Any idea why?
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?
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.
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.
It looks like you're new here. Sign in or register to get started.
