QueryDSL: Query Syntax | Notion

H2-1. Conditions

Condition	Description	Category	Example
eq	Equal	`Comparison`	`slave.slaveName.eq(”slave1”)`
ne	Not Equal	`Comparison`	`slave.slaveName.ne(”slave1”)`
eq(”cond”).not	Equal Not	`Comparison`	`slave.slaveName.eq(”slave1”).not()`
isNotNull	!null	`Existence`	`slave.slaveName.isNotNull()`
in	Include	`Existence`	`slave.age.in(20, 30)`
notIn	Not Include	`Existence`	`slave.age.notIn(20, 30)`
between		`Existence`	`slave.age.between(20, 30)`
goe	Greater than Or Equal	`Comparison`	`slave.age.goe(30)`
gt	Greater Than	`Comparison`	`slave.age.gt(30)`
loe	Lower than Or Equal	`Comparison`	`slave.age.loe(30)`
lt	Lower Than	`Comparison`	`slave.age.lt(30)`
like	Pattern	`Pattern`	`slave.slaveName.like("slave%")`
contains	= like ‘%cond%’	`Pattern`	`slave.slaveName.contains("slave")`
startsWith	= list ‘cond%’	`Pattern`	`slave.slaveName.startsWith("slave")`

H2-2. Basic Syntax

Category	Link or Description
AND 조건 처리	‣
결과 조회	• `fetch()` : getListResults
• `fetchOne()` : getSingleResults (nullable)
• `fetchFirst()` : limit(1).fetchOne()

• ~~fetchResults() : Paging 정보 포함, total count 쿼리 추가 실행~~ • ~~fetchCount() : count 쿼리로 변경해서 count 수 조회~~ | | Sorting | ‣ | | Paging | ‣ | | Aggregation Function | ‣ | | Join | ‣ | | SubQuery | ‣ | | Case | ‣ | | Const, Char | ‣ |

H2-3. Mid-Level Syntax

Category	Link or Description
Projection	‣
Dynamic Query	‣

H2-4. Working-Level Syntax

Category	Link or Description
Pure JPA vs QueryDSL	‣
Dynamic Query & Performance Optimization	‣
Search API Example	‣
Spring Data JPA & QueryDSL	‣
QueryDSL Paging	‣