native sql query

sriramanjaneya · **Joined:** Thu Aug 09, 2007 9:37 pm **Posts:** 5

plese reply with hql query for this

select avg(parm_value), site_id from mes_wat_mapraw where lot_id = 'MNA5076.00' and lot_type_flag='D01'
and test_type ='OQA'
and parm_name ='Isat_N4' group by site_id

thanx

kosh.iii · **Joined:** Mon Sep 10, 2007 5:26 am **Posts:** 2

Code:

select avg(mes.parm_value), mes.site_id
from MesWatMapraw as mes
where mes.lot_id = 'MNA5076.00'
and mes.lot_type_flag='D01'
and mes.test_type ='OQA'
and mes.parm_name ='Isat_N4'
group by mes.site_id

Replace

Code:

MesWatMapraw

with the actual name of your mapping class and check the properties as well - and you're done. If that's not the solution you probably should clarify your request and give some information on the table(s) and entities you use. (Posting the mapping file often helps.)