java.lang.Object
- org.apache.cayenne.exp.FunctionExpressionFactory

```
public class FunctionExpressionFactory
extends Object
```
Collection of factory methods to create function call expressions.

Since:

4.0

Constructor Summary

Constructors
Constructor Description

FunctionExpressionFactory()

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method	Description
`static Expression`	`absExp(String path)`
`static Expression`	`absExp(Expression exp)`
`static Expression`	`avgExp(Expression exp)`
`static Expression`	`concatExp(String... paths)`	Factory method for expression to call CONCAT(string1, string2, ...) function
`static Expression`	`concatExp(Expression... expressions)`	Factory method for expression to call CONCAT(string1, string2, ...) function
`static Expression`	`countDistinctExp(Expression exp)`
`static Expression`	`countExp()`
`static Expression`	`countExp(Expression exp)`
`static Expression`	`currentDate()`
`static Expression`	`currentTime()`
`static Expression`	`currentTimestamp()`
`static Expression`	`dayOfMonthExp(String path)`
`static Expression`	`dayOfMonthExp(Expression exp)`
`static Expression`	`dayOfWeekExp(String path)`
`static Expression`	`dayOfWeekExp(Expression exp)`
`static Expression`	`dayOfYearExp(String path)`
`static Expression`	`dayOfYearExp(Expression exp)`
`static Expression`	`hourExp(String path)`
`static Expression`	`hourExp(Expression exp)`
`static Expression`	`lengthExp(String path)`
`static Expression`	`lengthExp(Expression exp)`
`static Expression`	`locateExp(String substring, String path)`	Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
`static Expression`	`locateExp(String substring, Expression exp)`	Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
`static Expression`	`locateExp(Expression substring, Expression exp)`	Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
`static Expression`	`lowerExp(String path)`
`static Expression`	`lowerExp(Expression exp)`
`static Expression`	`maxExp(Expression exp)`
`static Expression`	`minExp(Expression exp)`
`static Expression`	`minuteExp(String path)`
`static Expression`	`minuteExp(Expression exp)`
`static Expression`	`modExp(String path, Number number)`
`static Expression`	`modExp(Expression exp, Number number)`
`static Expression`	`modExp(Expression exp, Expression number)`
`static Expression`	`monthExp(String path)`
`static Expression`	`monthExp(Expression exp)`
`static Expression`	`secondExp(String path)`
`static Expression`	`secondExp(Expression exp)`
`static Expression`	`sqrtExp(String path)`
`static Expression`	`sqrtExp(Expression exp)`
`static Expression`	`substringExp(String path, int offset, int length)`	Call SUBSTRING(string, offset, length) function
`static Expression`	`substringExp(Expression exp, int offset, int length)`	Call SUBSTRING(string, offset, length) function
`static Expression`	`substringExp(Expression exp, Expression offset, Expression length)`	Call SUBSTRING(string, offset, length) function
`static Expression`	`sumExp(Expression exp)`
`static Expression`	`trimExp(String path)`
`static Expression`	`trimExp(Expression exp)`
`static Expression`	`upperExp(String path)`
`static Expression`	`upperExp(Expression exp)`
`static Expression`	`weekExp(String path)`
`static Expression`	`weekExp(Expression exp)`
`static Expression`	`yearExp(String path)`
`static Expression`	`yearExp(Expression exp)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - FunctionExpressionFactory
```
public FunctionExpressionFactory()
```
- Method Detail
  - substringExp
```
public static Expression substringExp(Expression exp,
                                      int offset,
                                      int length)
```
    Call SUBSTRING(string, offset, length) function
    
    Parameters:
    
    exp - expression that must evaluate to string
    
    offset - start offset of substring
    
    length - length of substring
    
    Returns:
    
    SUBSTRING() call expression
  - substringExp
```
public static Expression substringExp(String path,
                                      int offset,
                                      int length)
```
    Call SUBSTRING(string, offset, length) function
    
    Parameters:
    
    path - Object path value
    
    offset - start offset of substring
    
    length - length of substring
    
    Returns:
    
    SUBSTRING() call expression
  - substringExp
```
public static Expression substringExp(Expression exp,
                                      Expression offset,
                                      Expression length)
```
    Call SUBSTRING(string, offset, length) function
    
    Parameters:
    
    exp - expression that must evaluate to string
    
    offset - start offset of substring must evaluate to int
    
    length - length of substring must evaluate to int
    
    Returns:
    
    SUBSTRING() call expression
  - trimExp
```
public static Expression trimExp(Expression exp)
```
    Parameters:
    
    exp - string expression to trim
    
    Returns:
    
    TRIM() call expression
  - trimExp
```
public static Expression trimExp(String path)
```
    Parameters:
    
    path - object path value
    
    Returns:
    
    TRIM() call expression
  - lowerExp
```
public static Expression lowerExp(Expression exp)
```
    Parameters:
    
    exp - string expression
    
    Returns:
    
    LOWER() call expression
  - lowerExp
```
public static Expression lowerExp(String path)
```
    Parameters:
    
    path - object path value
    
    Returns:
    
    LOWER() call expression
  - upperExp
```
public static Expression upperExp(Expression exp)
```
    Parameters:
    
    exp - string expression
    
    Returns:
    
    UPPER() call expression
  - upperExp
```
public static Expression upperExp(String path)
```
    Parameters:
    
    path - object path value
    
    Returns:
    
    UPPER() call expression
  - lengthExp
```
public static Expression lengthExp(Expression exp)
```
    Parameters:
    
    exp - string expression
    
    Returns:
    
    LENGTH() call expression
  - lengthExp
```
public static Expression lengthExp(String path)
```
    Parameters:
    
    path - object path value
    
    Returns:
    
    LENGTH() call expression
  - locateExp
```
public static Expression locateExp(String substring,
                                   Expression exp)
```
    Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
    
    Parameters:
    
    substring - object path value
    
    exp - string expression
    
    Returns:
    
    LOCATE() call expression
  - locateExp
```
public static Expression locateExp(String substring,
                                   String path)
```
    Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
    
    Parameters:
    
    substring - object path value
    
    path - object path
    
    Returns:
    
    LOCATE() call expression
  - locateExp
```
public static Expression locateExp(Expression substring,
                                   Expression exp)
```
    Call LOCATE(substring, string) function that return position of substring in string or 0 if it is not found.
    
    Parameters:
    
    substring - string expression
    
    exp - string expression
    
    Returns:
    
    LOCATE() call expression
  - absExp
```
public static Expression absExp(Expression exp)
```
    Parameters:
    
    exp - numeric expression
    
    Returns:
    
    ABS() call expression
  - absExp
```
public static Expression absExp(String path)
```
    Parameters:
    
    path - object path value
    
    Returns:
    
    ABS() call expression
  - sqrtExp
```
public static Expression sqrtExp(Expression exp)
```
    Parameters:
    
    exp - numeric expression
    
    Returns:
    
    SQRT() call expression
  - sqrtExp
```
public static Expression sqrtExp(String path)
```
    Parameters:
    
    path - object path value
    
    Returns:
    
    SQRT() call expression
  - modExp
```
public static Expression modExp(Expression exp,
                                Number number)
```
    Parameters:
    
    exp - numeric expression
    
    number - divisor
    
    Returns:
    
    MOD() call expression
  - modExp
```
public static Expression modExp(String path,
                                Number number)
```
    Parameters:
    
    path - object path value
    
    number - divisor
    
    Returns:
    
    MOD() call expression
  - modExp
```
public static Expression modExp(Expression exp,
                                Expression number)
```
    Parameters:
    
    exp - object path value
    
    number - numeric expression
    
    Returns:
    
    MOD() call expression
  - concatExp
```
public static Expression concatExp(Expression... expressions)
```
    Factory method for expression to call CONCAT(string1, string2, ...) function
    
    Can be used like:
    Expression concat = concatExp(SomeClass.POPERTY_1.getPath(), SomeClass.PROPERTY_2.getPath());
    
    SQL generation note:
    
    if DB supports CONCAT function with vararg then it will be used
    if DB supports CONCAT function with two args but also supports concat operator, then operator (eg ||) will be used
    if DB supports only CONCAT function with two args then it will be used what can lead to SQL exception if used with more than two arguments
    
    Currently only known DB with limited concatenation functionality is Openbase.
    Parameters:
    
    expressions - array of expressions
    
    Returns:
    
    CONCAT() call expression
  - concatExp
```
public static Expression concatExp(String... paths)
```
    Factory method for expression to call CONCAT(string1, string2, ...) function
    
    Can be used like:
    Expression concat = concatExp("property1", "property2");
    
    SQL generation note:
    
    if DB supports CONCAT function with vararg then it will be used
    if DB supports CONCAT function with two args but also supports concat operator, then operator (eg ||) will be used
    if DB supports only CONCAT function with two args then it will be used what can lead to SQL exception if used with more than two arguments
    
    Currently only Openbase DB has limited concatenation functionality.
    Parameters:
    
    paths - array of paths
    
    Returns:
    
    CONCAT() call expression
  - countExp
```
public static Expression countExp()
```
    Returns:
    
    Expression COUNT(*)
  - countExp
```
public static Expression countExp(Expression exp)
```
    Returns:
    
    Expression COUNT(exp)
  - countDistinctExp
```
public static Expression countDistinctExp(Expression exp)
```
    Returns:
    
    Expression COUNT(DISTINCT(exp))
    
    Since:
    
    4.1
  - minExp
```
public static Expression minExp(Expression exp)
```
    Returns:
    
    Expression MIN(exp)
  - maxExp
```
public static Expression maxExp(Expression exp)
```
    Returns:
    
    Expression MAX(exp)
  - avgExp
```
public static Expression avgExp(Expression exp)
```
    Returns:
    
    Expression AVG(exp)
  - sumExp
```
public static Expression sumExp(Expression exp)
```
    Returns:
    
    SUM(exp) expression
  - currentDate
```
public static Expression currentDate()
```
    Returns:
    
    CURRENT_DATE expression
  - currentTime
```
public static Expression currentTime()
```
    Returns:
    
    CURRENT_TIME expression
  - currentTimestamp
```
public static Expression currentTimestamp()
```
    Returns:
    
    CURRENT_TIMESTAMP expression
  - yearExp
```
public static Expression yearExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    year(exp) function expression
  - yearExp
```
public static Expression yearExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    year(path) function expression
  - monthExp
```
public static Expression monthExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    month(exp) function expression
  - monthExp
```
public static Expression monthExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    month(path) function expression
  - weekExp
```
public static Expression weekExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    week(exp) function expression
  - weekExp
```
public static Expression weekExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    week(path) function expression
  - dayOfYearExp
```
public static Expression dayOfYearExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    dayOfYear(exp) function expression
  - dayOfYearExp
```
public static Expression dayOfYearExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    dayOfYear(path) function expression
  - dayOfMonthExp
```
public static Expression dayOfMonthExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    dayOfMonth(exp) function expression, synonym for day()
  - dayOfMonthExp
```
public static Expression dayOfMonthExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    dayOfMonth(path) function expression, synonym for day()
  - dayOfWeekExp
```
public static Expression dayOfWeekExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    dayOfWeek(exp) function expression
  - dayOfWeekExp
```
public static Expression dayOfWeekExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    dayOfWeek(path) function expression
  - hourExp
```
public static Expression hourExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    hour(exp) function expression
  - hourExp
```
public static Expression hourExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    hour(path) function expression
  - minuteExp
```
public static Expression minuteExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    minute(exp) function expression
  - minuteExp
```
public static Expression minuteExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    minute(path) function expression
  - secondExp
```
public static Expression secondExp(Expression exp)
```
    Parameters:
    
    exp - date/timestamp expression
    
    Returns:
    
    second(exp) function expression
  - secondExp
```
public static Expression secondExp(String path)
```
    Parameters:
    
    path - String path
    
    Returns:
    
    second(path) function expression

Class FunctionExpressionFactory

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

FunctionExpressionFactory

Method Detail

substringExp

substringExp

substringExp

trimExp

trimExp

lowerExp

lowerExp

upperExp

upperExp

lengthExp

lengthExp

locateExp

locateExp

locateExp

absExp

absExp

sqrtExp

sqrtExp

modExp

modExp

modExp

concatExp

concatExp

countExp

countExp

countDistinctExp

minExp

maxExp

avgExp

sumExp

currentDate

currentTime

currentTimestamp

yearExp

yearExp

monthExp

monthExp

weekExp

weekExp

dayOfYearExp

dayOfYearExp

dayOfMonthExp

dayOfMonthExp

dayOfWeekExp

dayOfWeekExp

hourExp

hourExp

minuteExp

minuteExp

secondExp

secondExp