org.hibernate.criterion

Class Subqueries

java.lang.Object

org.hibernate.criterion.Subqueries

public class Subqueries
extends java.lang.Object

Factory class for criterion instances that represent expressions involving subqueries.

See Also:

Restrictions, Projection, Criteria

Method Summary

Modifier and Type	Method and Description
static Criterion	eq(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a given literal as being equal to the value in the subquery result.
static Criterion	eqAll(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal equals ALL the values in the subquery result.
static Criterion	exists(DetachedCriteria dc) Creates a criterion which checks for the existence of rows in the subquery result
static Criterion	ge(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a given literal as being greater-than-or-equal-to the value in the subquery result.
static Criterion	geAll(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is greater-than-or-equal-to ALL the values in the subquery result.
static Criterion	geSome(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is greater-than-or-equal-to SOME of the values in the subquery result.
static Criterion	gt(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a given literal as being greater-than the value in the subquery result.
static Criterion	gtAll(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is greater-than ALL the values in the subquery result.
static Criterion	gtSome(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is greater-than SOME of the values in the subquery result.
static Criterion	in(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is IN the values in the subquery result.
static Criterion	le(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a given literal as being less-than-or-equal-to the value in the subquery result.
static Criterion	leAll(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is less-than-or-equal-to ALL the values in the subquery result.
static Criterion	leSome(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is less-than-or-equal-to SOME of the values in the subquery result.
static Criterion	lt(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a given literal as being less-than the value in the subquery result.
static Criterion	ltAll(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is less-than ALL the values in the subquery result.
static Criterion	ltSome(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is less-than SOME of the values in the subquery result.
static Criterion	ne(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a given literal as being not-equal to the value in the subquery result.
static Criterion	notExists(DetachedCriteria dc) Creates a criterion which checks for the non-existence of rows in the subquery result
static Criterion	notIn(java.lang.Object value, DetachedCriteria dc) Creates a criterion which checks that the value of a literal is NOT IN the values in the subquery result.
static Criterion	propertiesEq(java.lang.String[] propertyNames, DetachedCriteria dc) Creates a criterion which checks that the value of multiple given properties as being equal to the set of values in the subquery result.
static Criterion	propertiesIn(java.lang.String[] propertyNames, DetachedCriteria dc) Creates a criterion which checks that the value of multiple given properties as being in to the set of values in the subquery result.
static Criterion	propertiesNotEq(java.lang.String[] propertyNames, DetachedCriteria dc) Creates a criterion which checks that the value of multiple given properties as being not-equal to the set of values in the subquery result.
static Criterion	propertiesNotIn(java.lang.String[] propertyNames, DetachedCriteria dc) Creates a criterion which checks that the value of multiple given properties as being not-in to the set of values in the subquery result.
static Criterion	propertyEq(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property as being equal to the set of values in the subquery result.
static Criterion	propertyEqAll(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property equals ALL the values in the subquery result.
static Criterion	propertyGe(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is greater-than-or-equal-to the value in the subquery result.
static Criterion	propertyGeAll(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is greater-than-or-equal-to ALL the values in the subquery result.
static Criterion	propertyGeSome(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is greater-than-or-equal-to SOME of the values in the subquery result.
static Criterion	propertyGt(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is greater-than the value in the subquery result.
static Criterion	propertyGtAll(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is greater-than ALL the values in the subquery result.
static Criterion	propertyGtSome(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is greater-than SOME of the values in the subquery result.
static Criterion	propertyIn(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is in the set of values in the subquery result.
static Criterion	propertyLe(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is less-than-or-equal-to the value in the subquery result.
static Criterion	propertyLeAll(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is less-than-or-equal-to ALL the values in the subquery result.
static Criterion	propertyLeSome(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is less-than-or-equal-to SOME of the values in the subquery result.
static Criterion	propertyLt(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is less-than the value in the subquery result.
static Criterion	propertyLtAll(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is less-than ALL the values in the subquery result.
static Criterion	propertyLtSome(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is less-than SOME of the values in the subquery result.
static Criterion	propertyNe(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is not equal to the value in the subquery result.
static Criterion	propertyNotIn(java.lang.String propertyName, DetachedCriteria dc) Creates a criterion which checks that the value of a given property is not-in the set of values in the subquery result.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

exists

public static Criterion exists(DetachedCriteria dc)

Creates a criterion which checks for the existence of rows in the subquery result

Parameters:

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

ExistsSubqueryExpression

notExists

public static Criterion notExists(DetachedCriteria dc)

Creates a criterion which checks for the non-existence of rows in the subquery result

Parameters:

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

ExistsSubqueryExpression

propertyEqAll

public static Criterion propertyEqAll(java.lang.String propertyName,
                                      DetachedCriteria dc)

Creates a criterion which checks that the value of a given property equals ALL the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyGtAll

public static Criterion propertyGtAll(java.lang.String propertyName,
                                      DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is greater-than ALL the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyLtAll

public static Criterion propertyLtAll(java.lang.String propertyName,
                                      DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is less-than ALL the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyGeAll

public static Criterion propertyGeAll(java.lang.String propertyName,
                                      DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is greater-than-or-equal-to ALL the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyLeAll

public static Criterion propertyLeAll(java.lang.String propertyName,
                                      DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is less-than-or-equal-to ALL the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyGtSome

public static Criterion propertyGtSome(java.lang.String propertyName,
                                       DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is greater-than SOME of the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyLtSome

public static Criterion propertyLtSome(java.lang.String propertyName,
                                       DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is less-than SOME of the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyGeSome

public static Criterion propertyGeSome(java.lang.String propertyName,
                                       DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is greater-than-or-equal-to SOME of the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyLeSome

public static Criterion propertyLeSome(java.lang.String propertyName,
                                       DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is less-than-or-equal-to SOME of the values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyIn

public static Criterion propertyIn(java.lang.String propertyName,
                                   DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is in the set of values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyNotIn

public static Criterion propertyNotIn(java.lang.String propertyName,
                                      DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is not-in the set of values in the subquery result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyEq

public static Criterion propertyEq(java.lang.String propertyName,
                                   DetachedCriteria dc)

Creates a criterion which checks that the value of a given property as being equal to the set of values in the subquery result. The implication is that the subquery returns a single result..

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyNe

public static Criterion propertyNe(java.lang.String propertyName,
                                   DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is not equal to the value in the subquery result. The assumption is that the subquery returns a single result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression

propertyGt

public static Criterion propertyGt(java.lang.String propertyName,
                                   DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is greater-than the value in the subquery result. The assumption is that the subquery returns a single result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression, propertyGtAll(java.lang.String, org.hibernate.criterion.DetachedCriteria), propertyGtSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)

propertyLt

public static Criterion propertyLt(java.lang.String propertyName,
                                   DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is less-than the value in the subquery result. The assumption is that the subquery returns a single result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression, propertyLtAll(java.lang.String, org.hibernate.criterion.DetachedCriteria), propertyLtSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)

propertyGe

public static Criterion propertyGe(java.lang.String propertyName,
                                   DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is greater-than-or-equal-to the value in the subquery result. The assumption is that the subquery returns a single result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression, propertyGeAll(java.lang.String, org.hibernate.criterion.DetachedCriteria), propertyGeSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)

propertyLe

public static Criterion propertyLe(java.lang.String propertyName,
                                   DetachedCriteria dc)

Creates a criterion which checks that the value of a given property is less-than-or-equal-to the value in the subquery result. The assumption is that the subquery returns a single result.

Parameters:

propertyName - The name of the property to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertySubqueryExpression, propertyLeAll(java.lang.String, org.hibernate.criterion.DetachedCriteria), propertyLeSome(java.lang.String, org.hibernate.criterion.DetachedCriteria)

propertiesEq

public static Criterion propertiesEq(java.lang.String[] propertyNames,
                                     DetachedCriteria dc)

Creates a criterion which checks that the value of multiple given properties as being equal to the set of values in the subquery result. The implication is that the subquery returns a single result. This form is however implicitly using tuple comparisons

Parameters:

propertyNames - The names of the properties to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertiesSubqueryExpression

propertiesNotEq

public static Criterion propertiesNotEq(java.lang.String[] propertyNames,
                                        DetachedCriteria dc)

Creates a criterion which checks that the value of multiple given properties as being not-equal to the set of values in the subquery result. The assumption is that the subquery returns a single result. This form is however implicitly using tuple comparisons

Parameters:

propertyNames - The names of the properties to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertiesSubqueryExpression

propertiesIn

public static Criterion propertiesIn(java.lang.String[] propertyNames,
                                     DetachedCriteria dc)

Creates a criterion which checks that the value of multiple given properties as being in to the set of values in the subquery result. This form is implicitly using tuple comparisons

Parameters:

propertyNames - The names of the properties to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertiesSubqueryExpression

propertiesNotIn

public static Criterion propertiesNotIn(java.lang.String[] propertyNames,
                                        DetachedCriteria dc)

Creates a criterion which checks that the value of multiple given properties as being not-in to the set of values in the subquery result. This form is implicitly using tuple comparisons

Parameters:

propertyNames - The names of the properties to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

PropertiesSubqueryExpression

eqAll

public static Criterion eqAll(java.lang.Object value,
                              DetachedCriteria dc)

Creates a criterion which checks that the value of a literal equals ALL the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

gtAll

public static Criterion gtAll(java.lang.Object value,
                              DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is greater-than ALL the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

ltAll

public static Criterion ltAll(java.lang.Object value,
                              DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is less-than ALL the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

geAll

public static Criterion geAll(java.lang.Object value,
                              DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is greater-than-or-equal-to ALL the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

leAll

public static Criterion leAll(java.lang.Object value,
                              DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is less-than-or-equal-to ALL the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

gtSome

public static Criterion gtSome(java.lang.Object value,
                               DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is greater-than SOME of the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

ltSome

public static Criterion ltSome(java.lang.Object value,
                               DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is less-than SOME of the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

geSome

public static Criterion geSome(java.lang.Object value,
                               DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is greater-than-or-equal-to SOME of the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

leSome

public static Criterion leSome(java.lang.Object value,
                               DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is less-than-or-equal-to SOME of the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

in

public static Criterion in(java.lang.Object value,
                           DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is IN the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

notIn

public static Criterion notIn(java.lang.Object value,
                              DetachedCriteria dc)

Creates a criterion which checks that the value of a literal is NOT IN the values in the subquery result.

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

eq

public static Criterion eq(java.lang.Object value,
                           DetachedCriteria dc)

Creates a criterion which checks that the value of a given literal as being equal to the value in the subquery result. The implication is that the subquery returns a single result..

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

ne

public static Criterion ne(java.lang.Object value,
                           DetachedCriteria dc)

Creates a criterion which checks that the value of a given literal as being not-equal to the value in the subquery result. The implication is that the subquery returns a single result..

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

gt

public static Criterion gt(java.lang.Object value,
                           DetachedCriteria dc)

Creates a criterion which checks that the value of a given literal as being greater-than the value in the subquery result. The implication is that the subquery returns a single result..

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

lt

public static Criterion lt(java.lang.Object value,
                           DetachedCriteria dc)

Creates a criterion which checks that the value of a given literal as being less-than the value in the subquery result. The implication is that the subquery returns a single result..

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

ge

public static Criterion ge(java.lang.Object value,
                           DetachedCriteria dc)

Creates a criterion which checks that the value of a given literal as being greater-than-or-equal-to the value in the subquery result. The implication is that the subquery returns a single result..

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression

le

public static Criterion le(java.lang.Object value,
                           DetachedCriteria dc)

Creates a criterion which checks that the value of a given literal as being less-than-or-equal-to the value in the subquery result. The implication is that the subquery returns a single result..

Parameters:

value - The literal value to use in comparison

dc - The detached criteria representing the subquery

Returns:

The Criterion

See Also:

SimpleSubqueryExpression