ObjectDB Database Search

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression nullif (    Expression  x,    Y y ) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not. Parameters

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsDouble (    Expression  x ) Create an aggregate expression applying the sum operation to a Float-valued expression , returning a Double result. Parameters: x - expression representing input value to sum operation Return: sum expression Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsLong (    Expression  x ) Create an aggregate expression applying the sum operation to an Integer-valued expression , returning a Long result. Parameters: x - expression representing input value to sum operation Return: sum expression Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.Subquery Subquery groupBy (    Expression ... 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

 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

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

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression right (    Expression  x,    int len ) Create an expression for the rightmost substring of a string, Parameters: x - string expression len - length of the substring to return Return: expression for the rightmost substring Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression left (    Expression  x,    int len ) Create an expression for the leftmost substring of a string, Parameters: x - string expression len - length of the substring to return Return: expression for the leftmost substring Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression replace (    Expression  x,    String substring,    String replacement ) Create an expression replacing every occurrence of a substring within a string. Parameters: x

;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

; 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 jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.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

JPA Method in jakarta.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

 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. Parameters: grouping - list of zero or

JPA Method in jakarta.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

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

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

JPA Method in jakarta.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 jakarta.persistence.criteria.CriteriaBuilder Expression toLong (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toInteger (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toString (    Expression  character ) Typecast. Returns same expression object. Parameters: character - expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toBigDecimal (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toBigInteger (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toDouble (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal Expression } Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression toFloat (    Expression  number ) Typecast. Returns same expression object. Parameters: number - numeric expression Return: {@literal 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 jakarta.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$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 jakarta.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 jakarta.persistence.criteria.CriteriaBuilder Expression count (    Expression  x ) Create an aggregate expression applying the count operation. Parameters: x - expression representing input value to count operation Return: count expression Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression least (    Expression  x ) Create an aggregate expression for finding the least of the values (strings, dates, etc). Parameters: x - expression representing input value to least operation Return: least expression Since: JPA 2.0

JPA Method in jakarta.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 jakarta.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 jakarta.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 jakarta.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 jakarta.persistence.criteria.CriteriaBuilder Expression locate (    Expression  x,    String pattern ) Create expression to locate the position ... : x - expression for string to be searched pattern - string to be located Return: expression corresponding to position Since: JPA 2.0

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

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

JPA Method in jakarta.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 jakarta.persistence.criteria.CriteriaBuilder Expression min (    Expression  x ) Create an aggregate expression applying the numerical min operation. Parameters: x - expression representing input value to min operation Return: min expression Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression greatest (    Expression  x ) Create an aggregate expression for finding the greatest of the values (strings, dates, etc). Parameters: x - expression representing input value to greatest operation Return: greatest expression Since: JPA 2.0

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

JPA Method in jakarta.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

JPA Method in jakarta.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 jakarta.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