DDC-2793: Subquery into FROM #3493

New Issue

admin · 2026-01-22T14:20:53+01:00

admin commented

2026-01-22 14:20:53 +01:00

Originally created by @doctrinebot on GitHub (Nov 14, 2013).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user pcastrotigre:

I am trying to do something like:

SELECT count(A.*) FROM (SELECT u FROM Acme\Bundle\Entity\User u ) A

This is not exactly the query i need, but that is the idea. The subquery into the FROM is not supported by the Query Builder neither the DQL because I am getting Error: Class '(' is not defined).

So how could I do this?

Originally created by @doctrinebot on GitHub (Nov 14, 2013). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user pcastrotigre: I am trying to do something like: ``` SELECT count(A.*) FROM (SELECT u FROM Acme\Bundle\Entity\User u ) A ``` This is not exactly the query i need, but that is the idea. The subquery into the FROM is not supported by the Query Builder neither the DQL because I am getting Error: Class '(' is not defined). So how could I do this?

admin added the Improvement label 2026-01-22 14:20:53 +01:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#3493