public function createQuery($context = 'list')
{
/** @var QueryBuilder $query */
$query = parent::createQuery($context);
$aliases = $query->getRootAliases();
if ($context === 'list') {
$query->select(sprintf('%s, p', $aliases[0]));
$query->leftJoin(sprintf('%s.page', $aliases[0]), 'p');
}
return $query;
}
/**
* @param string $context
* @return \Sonata\AdminBundle\Datagrid\ProxyQueryInterface
*/
public function createQuery($context = 'list')
{
$query = parent::createQuery($context);
if ($context == 'list') {
$query->addSelect('c');
$query->leftJoin(sprintf('%s.contentRoute', $query->getRootAlias()), 'c');
$query->orderBy('c.path', 'asc');
}
return $query;
}
