본문 바로가기

JAVA/JPA

Query DSL Order by case when 넣는 방법

DateTimeExpression<LocalDateTime> casex = new CaseBuilder().when(copOpen.coPApproStatCd.eq("HOTC226003")).then(copOpen.createDttm) .otherwise(copOpen.coPOpenDttm); //ORDER BY query.orderBy(copOpen.coPApproStatCd.desc()).orderBy(casex.desc());