Doctrine 2 - How to use discriminator column in where clause

php doctrine-orm dql discriminator
Can Aydoğan picture Can Aydoğan · May 13, 2011 · Viewed 20.6k times · Source

I was used discriminator column in where clause like this:

//f = root entity
$qb = $this->createQueryBuilder('f');
$qb->add('where', 'f.format = \'image\' OR f.format = \'text\'');

I've got an error: "Message: [Semantical Error] line 0, col 73 near 'format = 'image'': Error: Class Entities\File\AbstractFile has no field or association named format"

How can i use discriminator column in where clause?

Thanks.

Answer

Koc picture Koc · May 13, 2011

I think that you should use INSTANCE OF

Related questions

How to select randomly with doctrine

Here is how I query my database for some words $query = $qb->select('w') ->from('DbEntities\Entity\Word', 'w') ->where('w.indictionary = 0 AND w.frequency > 3') ->orderBy('w.frequency', 'DESC') ->…

Read More
Doctrine 2: Query result as associative array

In my Repository class I use the following code to query: $query = $this->getEntityManager()->createQuery(" SELECT s.term, COUNT(s.term) AS freq FROM App\Entities\SearchTerm s GROUP BY s.term ORDER BY s.term ASC "); $…

Read More
Limit amount of records retrieved when using Doctrine DQL in Symfony2

I have the following query: $latestcontent = $em->createQuery(' SELECT c.title, c.content, c.lastedit, a.firstname, a.surname FROM ShoutMainBundle:Content c, ShoutMainBundle:Admin a WHERE c.author = a.id ORDER BY c.lastedit ASC' ); What I …

Read More