php - How to convert SQL query with subquery to Doctrine QueryBuilder format?

Question

I want to transcribe this sql statement to doctrine format. It was complicated because I don't know how to perform subqueries. The sentence is as follows:

SELECT * FROM articulo WHERE descripcion = (SELECT descripcion FROM articulo WHERE codigo LIKE 4060981104537)

question from:https://stackoverflow.com/questions/65901882/how-to-convert-sql-query-with-subquery-to-doctrine-querybuilder-format

Answer 1

You can use Doctrine expression API for subqueries. Example for your query:

you should put following code to Doctrine repository of your articulo entity

$codigo = '4060981104537';
$qb = $this->createQueryBuilder('a');

$qb->where(
  $qb->expr()->in(
    'a.descripcion',
     $this->createQueryBuilder('a2')
       ->select('a2.descripcion')
       ->where('a2.codigo LIKE :codigo')
       ->setParameter('codigo', $codigo)
       ->getDQL()
     )
);