ObjectDB Database Search

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression countDistinct (    Expression  x ) Create an aggregate expression applying the count distinct operation. Parameters: x - expression representing input value to count distinct operation Return: count distinct expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression some (    Subquery  subquery ) Create a some expression over the subquery results. This expression is equivalent to an any expression . Parameters: subquery - subquery Return: some expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression any (    Subquery  subquery ) Create an any expression over the subquery results. This expression is equivalent to a some expression . Parameters: subquery - subquery Return: any expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate and (    Expression  x,     Expression  y ) Create a conjunction of the given boolean expressions . Parameters: x - boolean expression y - boolean expression Return: and predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate or (    Expression  x,     Expression  y ) Create a disjunction of the given boolean expressions . Parameters: x - boolean expression y - boolean expression Return: or predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toLong (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression <Long> Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toInteger (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression <Integer> Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toFloat (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression <Float> Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toDouble (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression <Double> Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toBigDecimal (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression <BigDecimal> Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toBigInteger (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: Expression <BigInteger> Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression toString (    Expression  character ) Typecast. Returns same expression object. Parameters: character - expression Return: Expression <String> Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression size (    Expression  collection ) Create an expression that tests the size of a collection. Parameters: collection - expression Return: size expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate like (    Expression  x,     Expression  pattern ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string expression Return: like predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate like (    Expression  x,     Expression  pattern,    char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate like (    Expression  x,    String pattern,     Expression  escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate notLike (    Expression  x,     Expression  pattern ) Create a predicate for testing whether the expression does not satisfy the given pattern. Parameters: x - string expression pattern - string expression Return: not-like predicate Since: JPA 2.0

; Expression  x,     Expression  pattern,    char escapeChar ) Create a predicate for testing whether the expression does not satisfy the given pattern. Parameters: x - string expression pattern - string expression escapeChar - escape character Return: not-like predicate Since: JPA 2.0

; Expression  x,    String pattern,     Expression  escapeChar ) Create a predicate for testing whether the expression does not satisfy the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character expression Return: not-like predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression concat (    Expression  x,    String y ) Create an expression for string concatenation. Parameters: x - string expression y - string Return: expression corresponding to concatenation Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression concat (   String x,     Expression  y ) Create an expression for string concatenation. Parameters: x - string y - string expression Return: expression corresponding to concatenation Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression substring (    Expression  x,    int from ) Create an expression for substring extraction ... is 1. Parameters: x - string expression from - start position Return: expression corresponding to substring extraction Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression substring (    Expression  x,    int from,    int len ) Create an expression for substring extraction. Extracts a substring of given length starting at the specified position

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression trim (    Expression  x ) Create expression to trim blanks from both ends of a string. Parameters: x - expression for string to trim Return: trim expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression trim (   char t,     Expression  x ) Create expression to trim character from both ends of a string. Parameters: t - character to be trimmed x - expression for string to trim Return: trim expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression lower (    Expression  x ) Create expression for converting a string to lowercase. Parameters: x - string expression Return: expression to convert to lowercase Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression upper (    Expression  x ) Create expression for converting a string to uppercase. Parameters: x - string expression Return: expression to convert to uppercase Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression length (    Expression  x ) Create expression to return length of a string. Parameters: x - string expression Return: length expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression locate (    Expression  x,    String pattern ) Create expression to locate the position ... - expression for string to be searched pattern - string to be located Return: expression corresponding to position Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression locate (    Expression  x,    String pattern,    int from ) Create expression to locate the position of one string within another, returning position of first character

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression coalesce (    Expression  x,    Y y ) Create an expression that returns null ... - expression y - value Return: coalesce expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder$Case CriteriaBuilder.Case when (    Expression  condition,     Expression  result ) Add a when/then clause to the case expression . Parameters: condition - "when" condition result - "then" result expression Return: general case expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder$Case Expression otherwise (    Expression  result ) Add an "else" clause to the case expression . Parameters: result - "else" result expression Return: expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase Expression otherwise (    Expression  result ) Add an "else" clause to the case expression . Parameters: result - "else" result expression Return: expression Since: JPA 2.0

 grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method only overrides the return type

... o ) Specify the ordering expressions that are used to order the query results. Replaces the previous ordering expressions , if any. If no ordering expressions are specified, the previous ... sequence of the ordering expressions determines the precedence, whereby the leftmost has highest

 o ) Specify the ordering expressions that are used to order the query results. Replaces the previous ordering expressions , if any. If no ordering expressions are specified, the previous ordering ... of the ordering expressions in the list determines the precedence, whereby the first element in the list

( Path  attribute,  Expression  value) Update the value of the specified attribute ... ; Expression  value) Update the value of the specified attribute. Parameters: attribute - attribute ... from: CommonAbstractCriteria Since: JPA 2.1 CriteriaUpdate where ( Expression  restriction

;grouping ) Specify the expressions that are used to form groups over the subquery results. Replaces the previous specified grouping expressions , if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method only overrides the return type

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression trim (   CriteriaBuilder.Trimspec ts,     Expression  x ) Create expression to trim blanks from a string. Parameters: ts - trim specification x - expression for string to trim Return: trim expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Expression trim (   CriteriaBuilder.Trimspec ts,    char t,     Expression  x ) Create expression to trim character from a string. Parameters: ts - trim specification t - character

JPA Method in javax.persistence.criteria.CriteriaBuilder Order asc (    Expression  x ) Create an ordering by the ascending value of the expression . Parameters: x - expression used to define the ordering Return: ascending ordering corresponding to the expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Order desc (    Expression  x ) Create an ordering by the descending value of the expression . Parameters: x - expression used to define the ordering Return: descending ordering corresponding to the expression Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate equal (    Expression  x,     Expression  y ) Create a predicate for testing the arguments for equality. Parameters: x - expression y - expression Return: equality predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate notEqual (    Expression  x,     Expression  y ) Create a predicate for testing the arguments for inequality. Parameters: x - expression y - expression Return: inequality predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate greaterThan (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is greater than the second. Parameters: x - expression y - expression Return: greater-than predicate Since: JPA 2.0

;  Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is greater than or equal to the second. Parameters: x - expression y - expression Return: greater-than-or-equal predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate lessThan (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is less than the second. Parameters: x - expression y - expression Return: less-than predicate Since: JPA 2.0

JPA Method in javax.persistence.criteria.CriteriaBuilder Predicate lessThanOrEqualTo (    Expression  x,     Expression  y ) Create a predicate for testing whether the first argument is less than or equal to the second. Parameters: x - expression y - expression Return: less-than-or-equal predicate Since: JPA 2.0

expressions , optionally including a "having" clause. When grouping is specified, each result expression must either be an expression contained in the grouping, or an aggregate evaluated once per group. Parameters: group a - comma-delimited list of expressions , optionally followed by the "having" keyword and a boolean expression Since: JDO 2.0