Symfony原则存储库按计数排序

Question

我有几个表，并得到结果。

$qb = $this->createQueryBuilder('a');
$qb->select("a, c, ac")
   ->leftJoin('a.categories', 'c')
   ->leftJoin('a.comments', 'ac')
   ->where('c.slug = :category')
   ->setParameter('category', $category)
   ->orderBy('a.name', 'ASC');
return $qb->getQuery();

我想要这个结果，按注释(ac)计数排序。我怎么解决这个问题?

Answer 1

$qb = $this->createQueryBuilder('a');
$qb->select("a, c, ac, count(a.comments) AS HIDDEN nbcomments")
   ->leftJoin('a.categories', 'c')
   ->leftJoin('a.comments', 'ac')
   ->where('c.slug = :category')
   ->setParameter('category', $category)
   ->orderBy('a.name', 'ASC')
   ->addOrderBy('nbcomments', 'ASC');
return $qb->getQuery();