Hello,

I have a problem related with the mapping of the results of a HQL query.

My query is:

select t, count(distinct ut.ownerUserId), avg(ut.userTestMark) FROM Test t LEFT JOIN t.userTests ut

I want to map the results of the avg and count to 2 transient fields that i defined in the Test class. How should my query look like? Alternatively, if this is not possible, how should i change my approach in order to obtain those 2 fields without writing a native query?

Many thanks in advance.