I have an SQL query and i want to convert it into a HQL query:

SELECT MESSAGES.MESSAGEID, MESSAGES.TYPE, MESSAGES.AREA, MESSAGES.FLOW, MESSAGES.OTHERFLOWINFO,
MESSAGES.DATECREATED, MESSAGES.DATELASTUPDATED, MESSAGES.CONTEXT, MESSAGES.STATUS, MESSAGES.PARENT,
PROBTRACKING.USERID
FROM MESSAGES
LEFT OUTER JOIN PROBTRACKING
ON MESSAGES.MESSAGEID = PROBTRACKING.MESSAGEID
AND PROBTRACKING.PROBLEMSTATUS = 'Unresolved'

Can this be done, i don't want to use create SQL query for this as i have filters set up, Struggling a lot with the syntax!

Any help is much appreciated,

Thanks

I'm not aware of any tool that does this, but there is a tool that works the other way around: http://www.ayende.com/projects/nhibernate-query-analyzer.aspx. This at least gives you an opportunity to play around with HQL and directly see its SQl translation. It should not be too hard to enter HQL that exactly produces a query like the one you entered.

Hello,

this particular query cannot be written in HQL because of lack of support of the "where" keyword introduced in Hibernate 3.0. See http://jira.nhibernate.org/browse/NH-514 for details.

I have written an ugly hack as I want to keep my request in HQL: I translate the HQL request to SQL (thanks to Ayende for the NQA code availability) then insert my "on" statement after the "outer join" statement and then execute the query... It is well encapsulated and so not that ugly but still support for the "where" keyword in NH would of course be nicer!

Regards,