querydsl (2) 썸네일형 리스트형 queryDSL JOIN 클래스만들때 join관계 설정하고 public class ProjectVO{ @ManyToOne @JoinColumn(name = "OCR_DEPT_ID",referencedColumnName = "DEPT_ID") private DeptVO ocrDeptVO; } 객체 생성한다음에 QProjectVO projectVO = QProjectVO.projectVO; QDeptVO deptVO = QDeptVO.deptVO; innerjoin leftjoin List result = (List) queryFactory .select(Projections.fields(ProjectVO.class, projectVO.ProjectId, ProjectVO.DeptVO ) ) .from(projectVO) .inne.. queryDSL case When, decode new CaseBuilder() .when(~) .then(~) .otherwise() .as(~) new CaseBuilder() .when(pointEvent.pointStatus.in(PointStatus.USE, PointStatus.USE_CANCEL)) .then(pointEvent.pointAmount.multiply(-1)) .otherwise(pointEvent.pointAmount).as("pointAmount") 이전 1 다음