Hi All,

I defined a property with below query in formula

( select distinct hp.project_name
from help_projects hp, help_comments hc
where hp.project_id = this_.PROJECT_ID)

and it is generating below query while running the application

select this_.TICKET_ID as TICKET1_3_0_,
( select distinct hp.project_name
from help_projects hp, help_comments hc
where hp.project_id = this_.PROJECT_ID)
as formula0_0_,
from HELP_COMMENTS this_ where this_.priority=? and this_.status=? order by this_.CREATED_DT desc

Hibernate is defining alias name 'formula0_0_', is there a way we can give alias name to this query?? If not, can I use this alias name('formula0_0_') in the order by clause(it is in-built to Hibernate so whether this will change over a time)??

Thanks in advance.

Regards,
Sharath.

Why do you want to do that?

In sybase we cannot use a query in order by clause. When I want to do sort depending upon the value of the property it will use the formula query and sybase is throwing error.

Sharath.