how to convert sql query to hql format?
I want to convert the following query from SQL to HQL.
SELECT
student.first_name AS student_first_name,
course.name AS course_name,
course.id AS course_id,
admission.admission_no AS admission_admission_no,
attendance.status AS attendance_status,
case WHEN attendance.status=1 THEN 'P'
WHEN attendance.status=2 THEN 'A'
End as Status,
count(course.id) as Periods,
count(attendance.status) as Total,
time_table_item.tt_date AS time_table_item_tt_date,
attendance.student_batch_id AS attendance_student_batch_id
FROM
public.time_table_item time_table_item
INNER JOIN public.attendance attendance ON time_table_item.id = attendance.time_table_item_id
INNER JOIN public.syllabus_course syllabus_course ON syllabus_course.id = time_table_item.act_syl_course_id
INNER JOIN public.course course ON syllabus_course.course_id = course.id
INNER JOIN public.student_batch student_batch ON attendance.student_batch_id = student_batch.id
INNER JOIN public.admission admission ON student_batch.admission_id = admission.id
INNER JOIN public.student student ON admission.student_id = student.id
AND course.id = syllabus_course.course_id
INNER JOIN public.time_table time_table ON time_table_item.time_table_id = time_table.id
where
student_batch.batch_id= $P{Batch} and time_table.level_id= $P{Level} and syllabus_course.course_id = $P{Course}--course.id=9142294--course.id=9142294
group by
course.id, admission.admission_no,time_table_item.tt_date,attendance.student_batch_id,
student.first_name,attendance.status,course.name
order by
course.id, admission.admission_no,time_table_item.tt_date
Can i get the corresponding HQL query for this?
Please help
