GroupBy discriminator #5435

New Issue

admin · 2026-01-22T15:07:44+01:00

admin commented

2026-01-22 15:07:44 +01:00

Originally created by @raziel057 on GitHub (Feb 28, 2017).

Do you think it could be possible to allow to query grouping by discriminant. For example, we could be able to create a query builder like that, given the fact that we can have different kind of Participants:

/**
* ...
 * @ORM\DiscriminatorColumn(name="discr", type="string")
 * @ORM\DiscriminatorMap({
 *     "delegate" = "Delegate",
 *     "journalist" = "Journalist",
 *     ...
 * })
 */
class Participant {
...

$qb = $this->getEntityManager()->createQueryBuilder()
            ->select('DISCRIMINATOR(p) as type, COUNT(p) as count')
            ->from(Participant::class, 'p')
            ->groupBy('DISCRIMINATOR(p)');

Doctrine could simply convert the DISCRIMINATOR(p) to p.discr internally. What do you think about that?

Originally created by @raziel057 on GitHub (Feb 28, 2017). Do you think it could be possible to allow to query grouping by discriminant. For example, we could be able to create a query builder like that, given the fact that we can have different kind of Participants: ```php /** * ... * @ORM\DiscriminatorColumn(name="discr", type="string") * @ORM\DiscriminatorMap({ * "delegate" = "Delegate", * "journalist" = "Journalist", * ... * }) */ class Participant { ... ``` ```php $qb = $this->getEntityManager()->createQueryBuilder() ->select('DISCRIMINATOR(p) as type, COUNT(p) as count') ->from(Participant::class, 'p') ->groupBy('DISCRIMINATOR(p)'); ``` Doctrine could simply convert the ``DISCRIMINATOR(p)`` to ``p.discr`` internally. What do you think about that?

admin commented

2026-01-22 15:07:44 +01:00

@ghost commented on GitHub (Jul 9, 2020):

This could be used as ->orderBy('DISCRIMINATOR(p)') too, right? It would be good addition.

@ghost commented on GitHub (Jul 9, 2020): This could be used as `->orderBy('DISCRIMINATOR(p)')` too, right? It would be good addition.

admin commented

2026-01-22 15:07:45 +01:00

@beberlei commented on GitHub (Jul 10, 2020):

@guilhermeblanco what do you think?

@beberlei commented on GitHub (Jul 10, 2020): @guilhermeblanco what do you think?

admin commented

2026-01-22 15:07:46 +01:00