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