Besides using it for creating criteria subqueries, Detached Criteria Builder can also be used in conjunction with the new detachedSQLProjection() method to return a projected result based on a subquery. The detachedSQLProjection() method can be called just like any other Criteria Builder projection.
Transform
Description
detachedSQLProtection
A single or array of DetachedCriteriaBuilders which will return the projected value
Examples
1
c =newCriteria();
2
c.withProjections(
3
detachedSQLProjection=
4
c.createSubcriteria("Car","Car2")
5
.withProjections( count="Car2.Year")
6
.isLT("Year",javaCast("int",2006))
7
.isEQ("CarID","{alias}.CarID"),
8
groupProperty="Make"
9
).list();
Copied!
INFO If you need to use a property from the root entity in one of your criterias, simply prepend the property name with {alias}. MORE otice how a subquery method was not used in this example of the Detached Criteria Builder.