How to execute DQL query in Symfony2?

Question

I am trying to get objects from DQL query. Here is my code :

$em = $this->getDoctrine()->getRepository(Item::class);

$items = $em->createQuery($getQuery);
$items = $query->getResult();

$getQuery = DQL query string : SELECT from Entity WHERE ...

I am receiving error : Undefined method 'createQuery'. The method name must start with either findBy or findOneBy! I don't understand it, bcz this example is copied from official documentation. How I can execute DQL query in queryBuilder/createQuery?

Yes. namespace AppBundle\Repository; use Doctrine\ORM\EntityRepository; /** * ItemRepository * * This class was generated by the Doctrine ORM. Add your own custom * repository methods below. */ class ItemRepository extends EntityRepository { } — Mohim
– Mohim, Commented Sep 23, 2017 at 22:20
I mean the method body for getDoctrine(). Did you write it? — Oluwafemi Sule
– Oluwafemi Sule, Commented Sep 23, 2017 at 22:28

Oluwafemi Sule · Accepted Answer · 2017-09-23 23:12:54Z

1

Entity manager has a createQuery method.

$em = $this->getDoctrine()->getManager();

$query = $em->createQuery($getQuery);

$items = $query->getResult();

Repository has a createQueryBuilder method.

$em = $this->getDoctrine()->getManager();

$qb = $em->getRepository(Item::class)->createQueryBuilder();
$query = qb->select('[columns]')->from('Entity')->where('[condition]')->getQuery();
$items = $query->getResult();

edited Sep 23, 2017 at 23:12

answered Sep 23, 2017 at 22:35

Oluwafemi Sule

39.3k1 gold badge63 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Mohim Over a year ago

Some progress. What method is used to get results? Attempted to call an undefined method named "getResult" of class "Doctrine\ORM\EntityManager". 500 Internal Server Error - UndefinedMethodException

Mohim Over a year ago

My IDE doesn't see method createQuery. Something is wrong with USE maybe?

Mohim Over a year ago

Referenced method is not found in subject class.

Oluwafemi Sule Over a year ago

createQuery is called on an entity manager while execute on a query object

Oluwafemi Sule Over a year ago

If you're using a repository, you can build a query with a query builder using createQueryBuilder and subsequent query builder methods

|

Collectives™ on Stack Overflow

How to execute DQL query in Symfony2?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related