I have read the documentation, as well as some previous posts related to this entry...i.e. being able to use expressions in the select clause.

Basically, how can I do something like this (I am just giving a simple example...the actual query involves lot of tables and joins):

select foo.field1, foo.field2, foo.field1*12+foo.field2 as total
from com.abc.xyz.hibernate.Foo as foo

From what I have read, it is not possible to use expressions in the select clause. This feature may be implemented in some future 3.x release, but I would like to know the recommended approach to overcome this limitation. How do people circumvent this limitation in HQL?

Thanks in advance.

Regards,

Shireesh Thanneru

A mapped formula would work.

Or do the calculation in Java.

Worked like a charm. Thanks a lot! I appreciate it very much.

Thanks for your reply. Yeah, I know we can do it in Java. But if we do it in Java, then we cannot use the <b>order by</b> clause on this calculated value. I think I can even use the <b>order by</b> clause with the mapped formulas. If not for the order by clause, I think even this solution will work out well (unless if we really want to order the results in Java).