IFunctionBuilder

interface OCP\DB\QueryBuilder\IFunctionBuilder
This class provides a builder for sql some functions
Implemented by:OC\DB\QueryBuilder\FunctionBuilder\FunctionBuilder
Source:lib/public/DB/QueryBuilder/IFunctionBuilder.php#33

Methods

public OCP\DB\QueryBuilder\IFunctionBuilder::md5($input)
Calculates the MD5 hash of a given input
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#42

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

12.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::concat($x, $y)
Combines two input strings
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#53

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

12.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::substring($input, $start, $length=null)
Takes a substring from the input string
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#65

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

12.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::sum($field)
Takes the sum of all rows in a column
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#75

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

12.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::lower($field)
Transforms a string field or value to lower case
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#84

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

14.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::add($x, $y)
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#92

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

14.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::subtract($x, $y)
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#100

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

14.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::count($count="", $alias="")
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#109

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

14.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::max($field)
Takes the maximum of all rows in a column
If you want to get the maximum value of multiple columns in the same row, use `greatest` instead
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#121

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

18.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::min($field)
Takes the minimum of all rows in a column
If you want to get the minimum value of multiple columns in the same row, use `least` instead
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#133

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

18.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::greatest($x, $y)
Takes the maximum of multiple values
If you want to get the maximum value of all rows in a column, use `max` instead
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#145

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

18.0.0

public OCP\DB\QueryBuilder\IFunctionBuilder::least($x, $y)
Takes the minimum of multiple values
If you want to get the minimum value of all rows in a column, use `min` instead
Source:

lib/public/DB/QueryBuilder/IFunctionBuilder.php#157

Parameters:
Returns:

\OCP\DB\QueryBuilder\IQueryFunction

Since:

18.0.0