ObjectDB Database Search

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.CriteriaBuilder Expression count (    Expression x ) Create an aggregate expression applying the count operation. Parameters: x - expression representing input value to count operation Returns: count expression . Since: Jakarta Persistence (JPA) 1.0

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

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

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

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

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

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

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression locate (    Expression x ,    String pattern ) Create expression to locate ... . Parameters: x - expression for string to be searched pattern - string to be located Returns: expression

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression coalesce (    Expression x ,    Y y ) Create an expression that returns null ... - expression y - value Returns: coalesce 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

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

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

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder In in (    Expression expression ) Create predicate to test whether given expression is contained in a list of values. Parameters: expression - to be tested against list of values Returns: in predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression extract (    TemporalField field ,    Expression temporal ) Create an expression ... - a temporal field type temporal - a date, time, or datetime Returns: expression for the value of the extracted field. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression function (    String name ,    Class type ,    Expression ... args ) Create an expression for the execution of a database function. Parameters: name - function name args

;  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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression power (    Expression x ,    Number y ) Create an expression that returns the first argument raised to the power of its second argument. Parameters: x - base y - exponent Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression round (    Expression x ,    Integer n ) Create an expression that returns the first argument rounded to the number of decimal places given by the second argument. Parameters: x - base n

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate like (    Expression x ,    String pattern ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string Returns: like predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate isNull (    Expression x ) Create a predicate to test whether the expression is null. Parameters: x - expression Returns: is-null predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate isNotNull (    Expression x ) Create a predicate to test whether the expression is not null. Parameters: x - expression Returns: is-not-null predicate. Since: Jakarta Persistence (JPA) 1.0

where (    Expression restriction ) Modify the update query to restrict the target of the update 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 update query. Since: Jakarta Persistence (JPA) 1.0