Top "Dql" questions

Combine IS NULL and :value in Doctrine 2 DQL

Since other (old) questions didn't get proper answers, I'll try it again: I regularly come across a scenario, where I …

php symfony doctrine-orm doctrine dql

Search only by time in DateTime field in Symfony2 and Doctrine

I use Symfony 2 and Doctrine. In my database MySQL, I have a field of type DateTime. In my Repository file, …

mysql datetime symfony doctrine-orm dql

How to get date difference in Doctrine Query Language (dql)?

I have an entity named Auction with two fields of type datetime: date1 and date2. I would like to SELECT …

date datetime symfony doctrine dql

EMC Documentum DQL - How to delete repeating attribute

I have a few objects created on my database and I need to delete some of the repeating attributes related …

dql documentum dfc emc

How to select discriminator column in doctrine 2

I need some help when select only discriminator column from doctrine 2 when run the DQL below SELECT p.type FROM …

php symfony doctrine-orm dql discriminator

Nested select query in doctrine query builder

In a Symfony2 project: select * from ( select p.name as product, u.id, u.name from user u left join …

symfony doctrine-orm doctrine dql doctrine-query

Doctrine: Is it possible to INDEX BY a related field?

I have a Doctrine model (Assignment), which has a many-to-one relationship with another model (Region). Assignments are owned by users (…

doctrine-orm dql many-to-one

Doctrine - how to check if a collection contains an entity

I have two entities User and Article with many-to-many relation as Article can have many authors. class User { /** @var string */ …

doctrine-orm dql

INNER JOIN in DQL in Doctrine 2 / Zend Framework 2

I have an issue with DQL in Doctrine 2. Subqueries seem to be unavailable in DQL, so I don't know how …

doctrine-orm zend-framework2 dql doctrine-query