Functionality overview

This page provides an overview of the available functionality in the TypeSafeQueryBuilder.

Miscellaneous

• How it works
• TypeSafeValues
• Hql functions (avg/min/max/etc)
• Building an arithmetic value expression
• Adding custom HQL to the query
• Subquery

From related

• Defining multiple from clauses in a single query
• Specifying a custom HQL alias

Select related

• Selecting an object or object[] like with session.list()
• Selecting a second set of data to merge into the result
• Selecting a collection into the dto
• Selecting a value of a different type with a transformer
• Selecting values into embedded dtos
• Selecting values from embedded entities
• Selecting arbitrary TypeSafeValues

Where related

• Chaining restrictions
• Creating restriction groups
• Holding on to a restriction to query twice with altered restriction
• Using restriction predicates to reduce code clutter

Join related

• TypeSafeQueryBuilder JoinTypes
• HQL joining with

Order by related

• Ordering by a selection result dto field (functional sorting)

Group by related

• Using the result of a group by to select

Having related