$qb = $conn->createQueryBuilder()
->select('u.name')
->from('users', 'u')
->groupBy('u.lastLogin');
->addGroupBy('u.createdAt')
| public addGroupBy ( mixed $groupBy ) | ||
| $groupBy | mixed | The grouping expression. |
public function addGroupBy($groupBy)
{
if (empty($groupBy)) {
return $this;
}
$groupBy = is_array($groupBy) ? $groupBy : func_get_args();
return $this->add('groupBy', $groupBy, true);
} /**
* @param QueryBuilder $builder
* @param string $modelClass
*
* @return QueryBuilder
*/
protected function distinct(QueryBuilder $builder, $modelClass)
{
// emulate SELECT DISTINCT (group by primary key)
$primaryColumn = $this->getModelSchemes()->getPrimaryKey($modelClass);
$fullPrimaryColumn = $this->getColumn($modelClass, $this->getTableName($modelClass), $primaryColumn);
$builder->addGroupBy($fullPrimaryColumn);
return $builder;
}
