I'm trying to execute a query where I'm using an function as an order by clause in HQL. This works; however if I try to use the same function as an order by in criteria it fails saying no property with the function name exists.

I've been toying with the idea of fixing this problem in the NHibernate source, however I'm not sure whether the order by in HQL is slipping through due to shortcomings in the HQL parser or whether this should be acceptable behavior and should be migrated to the criteria interface.

Can anyone shed some light?

Cheers,

Symon.