我有以下 SQL 查询可以正常运行:
SELECT completed_by, count(*) AS Total
FROM tasks
WHERE completed_by is not null AND status = 1
GROUP BY completed_by
;
我正在使用Doctrine查询构建器进行操作,但是出现了错误,无法正常工作。
$parameters = array(
'status' => 1,
);
$qb = $repository->createQueryBuilder('log');
$query = $qb
->select(' log.completedBy, COUNT(log) AS Total')
->where('log.Status = :status')
->groupBy('log.completedBy')
->setParameters($parameters)
->getQuery();
我遇到以下错误:
[语义错误] 第0行,第21列处的 'completedBy,' 错误:无效的路径表达式。必须是状态字段路径表达式。