/** * {@inheritdoc} */ public function getDataGridQueryBuilder() { return parent::getQueryBuilder()->groupBy('user.id'); }
/** * {@inheritdoc} */ public function getDictionaryTranslations() { $qb = parent::getQueryBuilder()->leftJoin('WellCommerce\\AppBundle\\Entity\\DictionaryTranslation', 'dictionary_translation', 'WITH', 'dictionary.id = dictionary_translation.translatable')->groupBy('dictionary.identifier, dictionary_translation.locale')->select('dictionary.identifier,dictionary_translation.locale,dictionary_translation.translation'); $query = $qb->getQuery(); return $query->getArrayResult(); }