How can I get all data via doctrine except one?

Question

I am getting data via doctrine:

$pages = $this->getDoctrine()->getRepository(Pages::class)->findAll();

What I want to to is get all data, except the data with the slug cat

So I trying to achieve something like this:

$pages = $this->getDoctrine()->getRepository(Pages::class)->findAllExcept(['slug'=>'cat']);

score 4 · Accepted Answer · answered Nov 26 '18 at 13:12

4

It is good practice to use custom repository class.

<?php

namespace AppBundle\Repository;

use AppBundle\Entity\Pages
use Doctrine\ORM\EntityRepository;

class PagesRepository extends EntityRepository
{
    /**
     * @param $slug
     * @return Pages[]
     */
    public function findAllExceptThis($slug)
    {
        return $this->createQueryBuilder('pages')
            ->andWhere('pages.slug != :slug')
            ->setParameter('slug', $slug)
            ->getQuery()
            ->execute();
    }
}

answered Nov 26 '18 at 13:12

Zamir

449
1
8
17

Thank you! This means with getDoctrine, this is not possible? – peace_love Nov 26 '18 at 13:14
I mentioned in here https://symfony.com/doc/current/doctrine.html#querying-for-objects-the-repository, repository object allows you to run basic queries. – Zamir Nov 26 '18 at 13:21
So, I can use this object later like this? -->`$pages = $this->getDoctrine()->getRepository(Pages::class)->findAllExceptThis($slug);` – peace_love Nov 26 '18 at 13:25
And you should edit Pages entity as like this @ORM\Entity(repositoryClass="AppBundle\Repository\PagesRepository") – Zamir Nov 26 '18 at 13:27
I try to generate it, but I get the error message ` Namespace "AppBundle" does not contain any mapped entities.` – peace_love Nov 26 '18 at 13:33
What is your bundle name? – Zamir Nov 26 '18 at 13:43
Now I understood how to do it. I already had this repository. Now everything works! – peace_love Nov 26 '18 at 14:02

How can I get all data via doctrine except one?

1 Answers1