Top "Dql" questions

how to get the difference between 2 dates with Dql

How can I get the difference between 2 dates with Dql? I have tried the following code, but that didn't work. $…

symfony doctrine-orm dql

Cannot select entity through identification variables without choosing at least one root entity alias

Ads entity is described by geographic information: Country> Region>County. The Ads entity is only linked with County. …

symfony join doctrine-orm inner-join dql

Doctrine DQL, class table inheritance and access to subclass fields

I have a problem with a DQL query and entity specialization. I have an Entity called Auction, which is OneToOne …

php inheritance doctrine-orm doctrine dql

How can I order by NULL in DQL?

I'm building an app using Symfony2 framework and using Doctrine ORM. I have a table with airlines for which some …

symfony doctrine-orm dql

Group by using month, year in doctrine2

How to write a following SQL query in doctrine2 as DQL . SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 …

doctrine dql

Request on key/value in a JSON type field with Doctrine2

I'm trying to figure out how, in a symfony 3.4 app, to retrieve (through a repository method, with a DQL request …

json symfony doctrine mariadb dql

How to return object from a DQL query?

I have written a DQL query in Doctrine 2: $qb->select('r.position') ->from('\Entities\Races', 'r') …

php doctrine-orm dql

DQL: enable (return_top 10) performance impact

I had this query that originally caused massive timeouts: select d.r_object_id from isc_fiche d, dmr_con …

dql documentum

SQL How do i query a many to many relationship

if i have a many to many relationship between posts and tags, how do i select posts that contain a …

doctrine dql

DQL - leftJoin() error: Expected Literal, got 'JOIN'

This code: $builder->select('p') ->from('ProProposalBundle:Proposal', 'p') ->leftJoin('ProProposalBundle:Proposal:Vote', 'v') -&…

symfony dql