๐Ÿ“˜
Kotlin JDSL
Discord
ko
ko
  • Kotlin JDSL
  • JPQL with Kotlin JDSL
    • Statements
    • Entities
    • Paths
    • Expressions
    • Predicates
    • Sorts
    • Subqueries
    • Custom DSL
    • Spring supports
    • Migration 2.X to 3.X
  • Kotlin JDSL Roadmap
  • FAQ
    • ์–ด๋–ป๊ฒŒ ์ƒ์„ฑ๋œ ์ฟผ๋ฆฌ๋ฅผ ๋ณผ ์ˆ˜ ์žˆ๋‚˜์š”?
    • Kotlin value class ๋ฅผ ์‚ฌ์šฉํ•˜๋ ค๋ฉด ์–ด๋–ป๊ฒŒ ํ•ด์•ผํ• ๊นŒ์š”?
    • Kotlin JDSL๊ณผ jOOQ, QueryDSL์˜ ์ฐจ์ด์ ์€ ๋ฌด์—‡์ธ๊ฐ€์š”?
    • ์™œ Kotlin JDSL์€ Nullableํ•œ ๋ฐ˜ํ™˜ ํƒ€์ž…์„ ํ—ˆ์šฉํ•˜๋‚˜์š”?
Powered by GitBook
On this page
  1. JPQL with Kotlin JDSL

Sorts

PreviousPredicatesNextSubqueries

Last updated 1 year ago

Kotlin JDSL์€ JPQL์˜ order-by item์„ ํ‘œํ˜„ํ•˜๊ธฐ ์œ„ํ•ด Sort ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ๊ฐ€์ง€๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค. Sort๋ฅผ ๋งŒ๋“ค๊ธฐ ์œ„ํ•ด, asc()์™€ desc()๋ฅผ ๋’ค์— ๋ถ™์—ฌ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

path(Book::isbn).asc()

path(Book::isbn).desc()

Null order

Sort์˜ nullsFirst()์™€ nullsLast()๋ฅผ ํ˜ธ์ถœํ•˜๋Š” ๊ฒƒ์œผ๋กœ null์ด ์กฐํšŒ ๊ฒฐ๊ณผ์˜ ์–ด๋””์— ๋‚˜ํƒ€๋‚˜์•ผ ํ•˜๋Š”์ง€ ํ‘œํ˜„ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

path(Employee::nickname).asc().nullsFirst()

path(Employee::nickname).asc().nullsLast()
Expression