Dynamic ordering (or one keeping the order of IDs in IN()) with HqlQuery

Topics: Core
Mar 8, 2014 at 5:36 PM
In a Projector provider (but probably it's the same with ContentManager.HqlQuery()) I'd like to sort the results in a unique way. Particularly I'd like the results to keep the order of their corresponding IDs in a previous IN() statement.

I've seen some very complex and hackish ways to achieve that but there should be a better solution.

Anybody done some ordering not on an existing property?
Mar 15, 2014 at 1:33 PM
Sooo... Anybody?