Skip to content

Instantly share code, notes, and snippets.

@roukmoute
Last active October 8, 2024 00:29
Show Gist options
  • Save roukmoute/d8b7473da78fc9d8b867 to your computer and use it in GitHub Desktop.
Save roukmoute/d8b7473da78fc9d8b867 to your computer and use it in GitHub Desktop.
Concrete example of WHERE...IN subquery in doctrine 2
<?php
class MyRepository extends EntityRepository
{
public function whereInSubQuery(User $user)
{
$queryBuilder = $this->createQueryBuilder('my_repository');
$queryBuilder
->where(
$queryBuilder->expr()->in(
'my_repository.skill',
$this
->createQueryBuilder('subquery_repository')
->select('skill.id')
->from('EntityBundle:Skill', 'skill')
->where('skill.user = :user')
->getDQL()
)
)
->setParameter(':user', $user);
return $queryBuilder->getQuery()->getResult();
}
}
@Paincakee
Copy link

thnx for this, it helped me

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment