HQL specify an order by property order?

How can I order by a specific property order in HQL?

For MySQL I can use: SELECT * FROM question q ORDER BY q.status IN ("DONE", "NO_ACTION"), q.status IN ("NEW","SAVED"), q.created DESC

but HQL doesn't allow in in order by.

Am I missing something? Is there some other way around this problem?

Tha开发者_运维百科nks

---

It seems to me that MySQL syntax using ORDER BY xxx IN (XXX,XXX...) is not SQL-ANSI supported function, it's a specific MySQL function.

So you should figure out another way to do what you want, by not using this function.

You can find here all the function supported by HQL.

---

Not to revive a dead question, but

SELECT * FROM question q ORDER BY q.status IN ("DONE", "NO_ACTION"), q.status HAVING q.status IN ("NEW", "SAVED")

Find "having clause"