Package org.hibernate.criterion
Class Subqueries
- java.lang.Object
-
- org.hibernate.criterion.Subqueries
-
public class Subqueries extends Object
Factory class for criterion instances that represent expressions involving subqueries.- See Also:
Restrictions
,Projection
,Criteria
-
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static Criterion
eq(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(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 resultstatic Criterion
ge(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(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(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(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(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(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(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(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(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(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(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(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(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(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 resultstatic Criterion
notIn(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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(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.
-
-
-
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(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGtAll
public static Criterion propertyGtAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyLtAll
public static Criterion propertyLtAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGeAll
public static Criterion propertyGeAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyLeAll
public static Criterion propertyLeAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGtSome
public static Criterion propertyGtSome(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyLtSome
public static Criterion propertyLtSome(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGeSome
public static Criterion propertyGeSome(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyLeSome
public static Criterion propertyLeSome(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyIn
public static Criterion propertyIn(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyNotIn
public static Criterion propertyNotIn(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyEq
public static Criterion propertyEq(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyNe
public static Criterion propertyNe(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertySubqueryExpression
-
propertyGt
public static Criterion propertyGt(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 comparisondc
- 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(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 comparisondc
- 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(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 comparisondc
- 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(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 comparisondc
- 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(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertiesSubqueryExpression
-
propertiesNotEq
public static Criterion propertiesNotEq(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertiesSubqueryExpression
-
propertiesIn
public static Criterion propertiesIn(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertiesSubqueryExpression
-
propertiesNotIn
public static Criterion propertiesNotIn(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
PropertiesSubqueryExpression
-
eqAll
public static Criterion eqAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
gtAll
public static Criterion gtAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
ltAll
public static Criterion ltAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
geAll
public static Criterion geAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
leAll
public static Criterion leAll(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
gtSome
public static Criterion gtSome(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
ltSome
public static Criterion ltSome(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
geSome
public static Criterion geSome(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
leSome
public static Criterion leSome(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
in
public static Criterion in(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
notIn
public static Criterion notIn(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
eq
public static Criterion eq(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
ne
public static Criterion ne(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
gt
public static Criterion gt(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
lt
public static Criterion lt(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
ge
public static Criterion ge(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
le
public static Criterion le(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 comparisondc
- The detached criteria representing the subquery- Returns:
- The Criterion
- See Also:
SimpleSubqueryExpression
-
-