From 8ef5a366eccaab850dab4641619c704a0b36f3d9 Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Wed, 4 Sep 2019 16:48:02 +0200 Subject: add MAX and MIN to functionbuilder Signed-off-by: Robin Appelman --- lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php') diff --git a/lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php b/lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php index a9d2f6f9a35..3b67661c8b0 100644 --- a/lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php +++ b/lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php @@ -76,4 +76,12 @@ class FunctionBuilder implements IFunctionBuilder { $alias = $alias ? (' AS ' . $this->helper->quoteColumnName($alias)) : ''; return new QueryFunction('COUNT(' . $this->helper->quoteColumnName($count) . ')' . $alias); } + + public function max($field) { + return new QueryFunction('MAX(' . $this->helper->quoteColumnName($field) . ')'); + } + + public function min($field) { + return new QueryFunction('MIN(' . $this->helper->quoteColumnName($field) . ')'); + } } -- cgit v1.2.3