Doctrine ODM Distinct With Limit

Question

I have the following problem: I can't limit number of results when using distinct. Exemple :

$stores = $this->dm->createQueryBuilder('Application\Document\Item')
   ->distinct('storeName')
   ->limit(10)
   ->getQuery()
   ->execute();

This query render 100 entries but I want only 10 results.

manix · Answer 1 · 2015-02-02T20:43:41.213

1

With query builder class in ORM you need to use:

->setMaxResults(10);

As per @Siol and @john Smith said, in ODM you could use limit:

->limit(10);

edited Feb 02 '15 at 20:43

answered Nov 07 '13 at 00:29

manix

14,537
11
70
107

1

setMaxResults() is only for Doctrine ORM and not ODM – Siol Nov 07 '13 at 06:25
for ODM\MongoDB\Query\Builder its just ->limit(1) – john Smith Jan 10 '14 at 19:23

score 0 · Answer 2 · answered Jul 05 '19 at 05:25

I don't think distinct will work with limit as suggested in the Jira mongodb issue ticket Ability to use Limit() with Distinct():

The current Distinct() implementation only allows for bringing back ALL distinct values in the collection or matching a query, but there is no way to limit these results. This would be very convenient and there are many use cases.

Doctrine ODM Distinct With Limit

2 Answers2