Consultas Utiles HQL

Seleccionar las ultimas 4 noticias
Query Name: getRecientNotices
Query: from Noticia n where n.id >= ( select (max(m.id)-4) from Noticia m) order by n.id desc

Consultas Utiles HQL

Buscar socios por especialidad
Query Name: getSocioByEspecialidad
Query: from Socio s where upper(s.especialidad) like upper('%'||:esp||'%')

Consultas Utiles HQL

Listar las actividades del mes y año actual




Query Name: getActividadActual
Query: from Actividad a where a.ano=(extract(year from current_timestamp())) and a.mes=CASE WHEN (extract(month from current_timestamp()))=1 THEN 'Enero'
WHEN (extract(month from current_timestamp()))=2 THEN 'Febrero'
WHEN (extract(month from current_timestamp()))=3 THEN 'Marzo'
WHEN (extract(month from current_timestamp()))=4 THEN 'Abril'
WHEN (extract(month from current_timestamp()))=5 THEN 'Mayo'
WHEN (extract(month from current_timestamp()))=6 THEN 'Junio'
WHEN (extract(month from current_timestamp()))=7 THEN 'Julio'
WHEN (extract(month from current_timestamp()))=8 THEN 'Agosto'
WHEN (extract(month from current_timestamp()))=9 THEN 'Septiembre'
WHEN (extract(month from current_timestamp()))=10 THEN 'Octubre'
WHEN (extract(month from current_timestamp()))=11 THEN 'Noviembre'
WHEN (extract(month from current_timestamp()))=12 THEN 'Diciembre'

END