DDC-805: Support subqueries in DQL ORDER BY #991

New Issue

admin · 2026-01-22T12:58:17+01:00

admin commented

2026-01-22 12:58:17 +01:00

Originally created by @doctrinebot on GitHub (Sep 14, 2010).

Jira issue originally created by user mjh_ca:

It would be nice to be able to do something like:

// Get "most voted" polls based on number of votes to poll answers

// DQL
SELECT p, a FROM Polls p INNER JOIN p.answers a ORDER BY (SELECT SUM(a2.answers) FROM PollAnswers a2 WHERE a2.poll = p) DESC

// SQL equivalent
SELECT /** ... **/ FROM polls p INNER JOIN poll*answers a ON (p.id = a.poll_id) ORDER BY (SELECT SUM(a2.answers) FROM poll_answers a2 WHERE a2.poll*id = p.id)

At present it seems that subqueries are not supported in ORDER BY

Originally created by @doctrinebot on GitHub (Sep 14, 2010). Jira issue originally created by user mjh_ca: It would be nice to be able to do something like: ``` // Get "most voted" polls based on number of votes to poll answers // DQL SELECT p, a FROM Polls p INNER JOIN p.answers a ORDER BY (SELECT SUM(a2.answers) FROM PollAnswers a2 WHERE a2.poll = p) DESC // SQL equivalent SELECT /** ... **/ FROM polls p INNER JOIN poll*answers a ON (p.id = a.poll_id) ORDER BY (SELECT SUM(a2.answers) FROM poll_answers a2 WHERE a2.poll*id = p.id) ``` At present it seems that subqueries are not supported in ORDER BY

admin added the Improvement label 2026-01-22 12:58:17 +01:00

admin closed this issue

2026-01-22 12:58:18 +01:00

admin commented

2026-01-22 12:58:19 +01:00

@doctrinebot commented on GitHub (Sep 15, 2010):

Comment created by @beberlei:

yes, becaues not all vendors support it.

Please use your own Result Set Mappings and Native Query to query for the desired result:

http://www.doctrine-project.org/projects/orm/2.0/docs/reference/native-sql/en#native-sql

@doctrinebot commented on GitHub (Sep 15, 2010): Comment created by @beberlei: yes, becaues not all vendors support it. Please use your own Result Set Mappings and Native Query to query for the desired result: http://www.doctrine-project.org/projects/orm/2.0/docs/reference/native-sql/en#native-sql

admin commented

2026-01-22 12:58:19 +01:00

@doctrinebot commented on GitHub (Sep 15, 2010):

Issue was closed with resolution "Invalid"

@doctrinebot commented on GitHub (Sep 15, 2010): Issue was closed with resolution "Invalid"

admin commented

2026-01-22 12:58:19 +01:00

@doctrinebot commented on GitHub (Sep 15, 2010):

Comment created by romanb:

hm. as a side note, correlated subqueries very often perform very badly when the tables get larger.

@doctrinebot commented on GitHub (Sep 15, 2010): Comment created by romanb: hm. as a side note, correlated subqueries very often perform **very** badly when the tables get larger.

admin referenced this issue

2026-01-22 14:30:12 +01:00

DDC-3127: [GH-1031] Documentation for #991 #3878

admin referenced this issue

2026-01-22 16:02:44 +01:00

[PR #991] [MERGED] Ability to define custom functions with callback instead of class name #9005

admin referenced this issue

2026-01-22 16:03:01 +01:00

[PR #1031] [MERGED] Documentation for #991 #9058

Sign in to join this conversation.