자주쓰는 Querydsl 함수/표현식 정리

Expressions.stringTemplate

Expressions.dateTemplate

 

MathExpressions

DateTimeExpression

BooleanExpression

StringExpression

 

CaseBuilder

ex) new CaseBuilder().when(~~).then(~~).otherwise(~~).as("test")

 

null 일때 coalesce

eq ===

ne !==

like 'abc'

contains '%abc%'

 

lt <

loe <=

gt >

goe >=

 

사용자함수 (ex. date)

Expressions.dateTemplate(Date.class, "function('DATE_SUB_INTERVAL',{0}, {1}, DAY)", "2021-01-01 00:00:00", 1))

MySQL56SpatialDialect => registerFunction("DATE_SUB_INTERVAL", new SQLFunctionTemplate(DateType.INSTANCE, "DATE_SUB(?1, INTERVAL ?2 ?3)"));