我希望使用DQL创建一个类似SQL的查询:
select
e.*
from
e
inner join (
select
uuid, max(locale) as locale
from
e
where
locale = 'nl_NL' or
locale = 'nl'
group by
uuid
) as e_ on e.uuid = e_.uuid and e.locale = e_.locale
我尝试使用QueryBuilder来生成查询和子查询。我认为它们本身做得很好,但我无法在联接语句中将它们组合起来。有人知道在DQL中是否可能吗?我不能使用本地SQL,因为我想返回真实的对象,并且我不知道为哪个对象运行此查询(我只知道具有uuid和locale属性的基类)。
$subQueryBuilder = $this->_em->createQueryBuilder();
$subQueryBuilder
->addSelect('e.uuid, max(e.locale) as locale')
->from($this->_entityName, 'e')
->where($subQueryBuilder->expr()->in('e.locale', $localeCriteria))
->groupBy('e.uuid');
$queryBuilder = $this->_em->createQueryBuilder();
$queryBuilder
->addSelect('e')
->from($this->_entityName, 'e')
->join('('.$subQueryBuilder.') as', 'e_')
->where('e.uuid = e_.uuid')
->andWhere('e.locale = e_.locale');