package com.healthcare.ohctech.repository; import com.healthcare.ohctech.entity.CheckupFormSection; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; import org.springframework.stereotype.Repository; import java.util.List; import java.util.Optional; @Repository public interface CheckupFormSectionRepo extends JpaRepository { Optional findById(Long id); // @Query(value = "SELECT s.section_name FROM checkup_form_section s WHERE s.section_id IN " + // "(SELECT c.checkup_form_section_ids FROM checkup_type c WHERE c.checkup_type_code = :code)" , nativeQuery = true) // List findSectionNamesByCheckupTypeCode(@Param("code") String checkupTypeCode); @Query(value = "SELECT s.section_id FROM checkup_form_section s WHERE s.section_id IN " + "(SELECT ct.checkup_form_section_ids FROM checkup_type ct WHERE ct.checkup_type_code = :checkupTypeCode)", nativeQuery = true) List findSectionIdsByCheckupTypeCode(String checkupTypeCode); }