Search Filter: Order by status dosen't give a proper result

[Treethawat Thanawachiramate]

Hello Everyone !,

When I'm doing a search through the search filter to seek for ticket/issue and order by status.

Example.

My Query: project = "Test Project" AND status in ("In Progress", Open, "On Hold") ORDER BY status ASC

The Result: Open, In Progress and On Hold

My expect result: In Progress, On Hold and Open

Is the search function looks those statuses in key id instead of alphabet? Because when I check on the View Statuses page, I found those key ids as follows:

• Open has id key = 1
• In Progress has id key = 3
• On Hold has id key = 10002

Would it be possible to arrange a result of status by using alphabet?

[Udo Brand]

Use a scripted Field (scriptrunner) with text searcher

issue.getStatusObject().getName();

 then order by that field.