Sunday, January 22, 2017

Native Query return entity



@Query(value = "select pkc.* " +
"from PPT_PERBANDINGAN pp " +
"inner join PPT_PERBANDINGAN_DETL ppd on pp.ID = ppd.ID_PPT_PERBANDINGAN " +
"inner join PPT_KETERAMPILAN_CALON pkc on pp.ID_SBK_PENUGASAN_PROGRAM = pkc.ID_SBK_PENUGASAN_PROGRAM " +
 "and pkc.ID = ppd.ID_PPT_KETERAMPILAN_CALON " +
"where pp.ID_SBK_PENUGASAN_PROGRAM = ? " +
"and pp.ID_WORK_ACTIVITIES = ?", nativeQuery = true)
List<PptKeterampilanCalon> getPptKeterampilanCalon(Long idSbkPenugasanProgram, Long cuId);

No comments:

Post a Comment