Top "Dql" questions

Limiting a doctrine query with a fetch-joined collection?

I have a doctrine query that returns blog posts and their comments: SELECT b, c FROM BlogPost b LEFT JOIN …

doctrine limit dql

Doctrine won't let me select specific fields

The symfony framework features an app/console file that can be executed via php to perform some maintenance tasks. It …

symfony doctrine-orm dql

DELETE query not working in DQL doctrine Symfony2

I am to delete a row based on ID, and i used this query to do the task: $em = $this-&…

symfony doctrine-orm dql

Doctrine Query Builder not working with UPDATE and INNER JOIN

In my repository I have this query: $qb = $this->getEntityManager()->createQueryBuilder(); $qb ->update('MyBundle:Entity1…

database symfony doctrine-orm dql

doctrine2 - how to use DATE_ADD function

I am trying to use the DATE_ADD function from doctrine2 but I am having trouble get it right. I …

symfony doctrine-orm dql

Invalid PathExpression. Must be a SingleValuedAssociationField

I'm trying to do: class PrixRepository extends EntityRepository { public function findPrixLike($film) { $query = $this->createQueryBuilder('p') ->addSelect(…

symfony doctrine-orm dql

DQL query to return all files in a Cabinet in Documentum?

I want to retrieve all the files from a cabinet (called 'Wombat Insurance Co'). Currently I am using this DQL …

sql database dql documentum dfc

How to ORDER BY DateTime in Doctrine 2?

I'm looking to execute the following query: $qb = $this->getEntityManager()->createQueryBuilder(); $qb->select( 'e' ) ->…

php sql symfony doctrine-orm dql

dql query error class is not defined

Trying to conver my sql queries into dql, seems im doing something wrong. I need basic joins, something like this. …

symfony doctrine dql

Doctrine 2 DQL - how to select inverse side of unidirectional many-to-many query?

I have two classes - Page and SiteVersion, which have a many to many relationship. Only SiteVersion is aware of …

php doctrine dql