带有SELECT、GROUP BY、COUNT语义错误的DQL原则

Question

我想执行如下查询：CCD_ 1。我尝试：

$entityManager->getRepository(Order::class)
->createQueryBuilder('o')
->select(["o.baseLang", "COUNT(o.id)"])
->groupBy("o.baseLang")
->getQuery()
->getResult();

，但我得到了Error: Invalid PathExpression. Must be a StateFieldPathExpression。我该怎么做？

Answer 1

您放入：

$entityManager->getRepository(Order::class)
->createQueryBuilder('o')
->select(["IDENTITY(o.baseLang)", "COUNT(o.id)"])
->groupBy("o.baseLang")
->getQuery()
->getResult();