[Spring] querydsl - 정렬

@Test
    public void sort() {
        em.persist(new Member(null, 100));
        em.persist(new Member("member5", 100));
        em.persist(new Member("member6", 100));
        
        List<Member> result = queryFactory
                .selectFrom(member)
                .where(member.age.eq(100))
                .orderBy(member.age.desc(), member.username.asc().nullsLast())
                .fetch();
                
        Member member5 = result.get(0);
        Member member6 = result.get(1);
        Member memberNull = result.get(2);
        
        assertThat(member5.getUsername()).isEqualTo("member5");
        assertThat(member6.getUsername()).isEqualTo("member6");
        assertThat(memberNull.getUsername()).isNull();
    }

desc() , asc() : 일반 정렬

nullsLast() , nullsFirst() : null 데이터 순서 부여

 

파라미터에 다중으로 조건 추가가능

 

출처 : 실전! Querydsl - 인프런 | 학습 페이지 (inflearn.com)