From a3391248e46bbc389dc1880f7ae50aa5dade8731 Mon Sep 17 00:00:00 2001 From: Joas Schilling Date: Tue, 8 Dec 2015 09:49:21 +0100 Subject: Add select distinct to the query builder --- lib/public/db/querybuilder/iquerybuilder.php | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'lib/public/db') diff --git a/lib/public/db/querybuilder/iquerybuilder.php b/lib/public/db/querybuilder/iquerybuilder.php index e3105cf134e..1ff1077d53f 100644 --- a/lib/public/db/querybuilder/iquerybuilder.php +++ b/lib/public/db/querybuilder/iquerybuilder.php @@ -256,6 +256,22 @@ interface IQueryBuilder { */ public function selectAlias($select, $alias); + /** + * Specifies an item that is to be returned uniquely in the query result. + * + * + * $qb = $conn->getQueryBuilder() + * ->selectDistinct('type') + * ->from('users'); + * + * + * @param mixed $select The selection expressions. + * + * @return \OCP\DB\QueryBuilder\IQueryBuilder This QueryBuilder instance. + * @since 9.0.0 + */ + public function selectDistinct($select); + /** * Adds an item that is to be returned in the query result. * -- cgit v1.2.3