Hi,

I am executing the below HqL query--

select v.visitId as visitId, max(v.startDt) as startDt
from com.zts.hygeia.dao.Visit as v
where (v.visitStatus!='SC' or v.visitStatus!='CL')
and v.visitType.visitCategory='ENC'
and v.patient.patientId = :patientId
group by v.visitId


It is returning a list of objests. and I need to get the values in a object . I tried casting it to a custom class with integer and date stamp still it can't do it.

Any suggestions

I think if you want to do this you need to make an object that matches what you select in the query.
I don't think Hibernate is very useful in this case.

this query returns a list of Object[]

Object[] row = (Object[])result.get(0);
Integer number = (Integer)row[0]; //visitId
Date order = (Date)row[1]; //startDt

You can also use a 'new' syntax in your query to obtain a result of Object (not array)...like that the query returns a list of "instance of your class"

of course class MyResult must declare a constructor where the type of parameters is the same type of returned field in select clause.

got it

Thanks .