ObjectDB Database Search

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder SimpleCase selectCase (    Expression expression ) Create a simple case expression . Parameters: expression - to be tested against the case conditions Returns: simple case expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (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 Returns: avg expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (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 Returns: sum expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression substring (    Expression x ,    int from ) Create an expression for substring ... position is 1. Parameters: x - string expression from - start position Returns: expression

Jakarta Persistence (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 position

Jakarta Persistence (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 Returns: expression corresponding to concatenation. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (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 Returns: expression corresponding to concatenation. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression trim (    char t ,    Expression x ) Create expression to trim character from both ends of a string. Parameters: x - expression for string to trim t - character to be trimmed Returns

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression lower (    Expression x ) Create expression for converting a string to lowercase. Parameters: x - string expression Returns: expression to convert to lowercase. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression upper (    Expression x ) Create expression for converting a string to uppercase. Parameters: x - string expression Returns: expression to convert to uppercase. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (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 Returns: trim expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression trim (    Trimspec ts ,    Expression x ) Create expression to trim blanks from a string. Parameters: x - expression for string to trim ts - trim specification Returns: trim expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression length (    Expression x ) Create expression to return length of a string. Parameters: x - string expression Returns: length expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (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 Returns

Jakarta Persistence (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 Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toLong (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toBigInteger (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toString (    Expression character ) Typecast. Returns same expression object. Parameters: character - expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.Case Expression otherwise (    Expression result ) Add an "else" clause to the case expression . Parameters: result - "else" result expression Returns: expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toInteger (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toFloat (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toDouble (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.SimpleCase Expression otherwise (    Expression result ) Add an "else" clause to the case expression . Parameters: result - "else" result expression Returns: expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression toBigDecimal (    Expression number ) Typecast. Returns same expression object. Parameters: number - numeric expression Returns: Expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression size (    Expression collection ) Create an expression that tests the size of a collection. Parameters: collection - expression Returns: size expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery select (    Expression expression ) Specify the item that is to be returned as the subquery result. Replaces the previously specified selection, if any. Parameters: expression - expression specifying

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression mod (    Integer x ,    Expression y ) Create an expression that returns the modulus (remainder under integer division) of its arguments. Parameters: x - value y - expression Returns: modulus. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.Coalesce Coalesce value (    Expression value ) Add an argument to the coalesce expression . Parameters: value - expression Returns: coalesce expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sqrt (    Expression x ) Create an expression that returns the square root of its argument. Parameters: x - expression Returns: square root. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression exp (    Expression x ) Create an expression that returns the exponential of its argument, that is, Euler's number e raised to the power of its argument. Parameters: x - expression Returns: exponential. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression ln (    Expression x ) Create an expression that returns the natural logarithm of its argument. Parameters: x - expression Returns: natural logarithm. Since: Jakarta Persistence (JPA) 1.0

SimpleCase when (    C condition ,    Expression result ) Add a when/then clause to the case expression . Parameters: result - "then" result expression condition - "when" condition Returns: simple case expression . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sign (    Expression x ) Create an expression that returns the sign of its argument, that is, 1 ... . Parameters: x - expression Returns: sign. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression neg (    Expression x ) Create an expression that returns the arithmetic negation of its argument. Parameters: x - expression Returns: arithmetic negation. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression abs (    Expression x ) Create an expression that returns the absolute value of its argument. Parameters: x - expression Returns: absolute value. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sum (    N x ,    Expression y ) Create an expression that returns the sum of its arguments. Parameters: x - value y - expression Returns: sum. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression prod (    Expression x ,    N y ) Create an expression that returns the product of its arguments. Parameters: x - expression y - value Returns: product. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression prod (    N x ,    Expression y ) Create an expression that returns the product of its arguments. Parameters: x - value y - expression Returns: product. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression ceiling (    Expression x ) Create an expression that returns the ceiling of its argument, that is, the smallest integer greater than or equal to its argument. Parameters: x - expression Returns: ceiling. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression floor (    Expression x ) Create an expression that returns the floor of its argument, that is, the largest integer smaller than or equal to its argument. Parameters: x - expression Returns: floor. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sum (    Expression x ,    N y ) Create an expression that returns the sum of its arguments. Parameters: x - expression y - value Returns: sum. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression quot (    Expression x ,    Number y ) Create an expression that returns the quotient of its arguments. Parameters: x - expression y - value Returns: quotient. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression quot (    Number x ,    Expression y ) Create an expression that returns the quotient of its arguments. Parameters: x - value y - expression Returns: quotient. Since: Jakarta Persistence (JPA) 1.0

;  Expression restriction ) Modify the subquery to restrict the result according to the specified boolean expression . Replaces the previously added restriction(s), if any. This method ... compound boolean expression Returns: the modified subquery. Since: Jakarta Persistence (JPA) 1.0

where (    Expression restriction ) Modify the query to restrict the query results according to the specified boolean expression . Replaces the previously added restriction(s), if any. Parameters: restriction - a simple or compound boolean expression Returns: the modified query. Since: Jakarta Persistence (JPA) 1.0

(    Expression x ,    String pattern ,    char escapeChar ) Create a predicate for testing whether the expression does not satisfy the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character Returns: not-like predicate. Since: Jakarta Persistence (JPA) 1.0

(    Expression x ,    String pattern ,    char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character Returns: like predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate notLike (    Expression x ,    String pattern ) Create a predicate for testing whether the expression does not satisfy the given pattern. Parameters: x - string expression pattern

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.Case Case when (    Expression condition ,    R result ) Add a when/then clause to the case expression . Parameters: result - "then" result value condition - "when" condition Returns: general case expression . Since: Jakarta Persistence (JPA) 1.0