Documentation / Query

  • Getting started
  • Introduction
  • Documentation
    • Best practice
    • Query
    • Persist
    • Transactions
    • Mapping
    • DDL & Migrations
    • Logging
    • Testing
    • Database platforms
    • Multiple databases
    • Kotlin
    • Tuning
    • Features
  • Getting help
  • API Javadoc
  • Videos
  • Upgrading
  • Releases
  • Docs Documentation
  • And 101 more...

Query beans

Where

Expressions

OrderBy

Select

Fetch

FetchGroup

FilterMany

Aggregation

Having

Native Sql

RawSql

Update query

Delete query

DtoQuery

SqlQuery

SqlUpdate

CallableSql


Find methods:

exists

findOne

findList

findMap

findNative (sql)

findIds

findCount

findEach

findStream

findIterate

findPagedList

findSingleAttribute

findVersions


Query options

distinct

forUpdate

disableLazyLoading

includeSoftDeletes

persistenceContextScope

all options


Background

Overview

Partial Objects

N plus 1

Query beans

Automatic query tuning