Class Subqueries

    • 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        PropertySubqueryExpression
      • 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - 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 comparison
        dc - The detached criteria representing the subquery
        Returns:
        The Criterion
        See Also:
        SimpleSubqueryExpression