DDC-201: Parent child association mapping and querying #249

New Issue

2026-01-22T12:32:12+01:00

admin commented

2026-01-22 12:32:12 +01:00

Originally created by @doctrinebot on GitHub (Dec 8, 2009).

Jira issue originally created by user thecelavi:

This function:

public function &getPageTreePortion($dirId = null) {

        $qb = $this->em->createQueryBuilder();
        if (is_null($dirId)) {
            $qb->select('DP')
                    ->from('Pleomorph\Entities\Core\Domain\PageDirectory', 'DP')
                    ->where('DP.parentDirectory.id IS NULL');
        } else {
            $qb->select('DP')
                    ->from('Pleomorph\Entities\Core\Domain\PageDirectory', 'DP')
                    ->where('DP.parentDirectory.id = ?1');
            $qb->setParameter(1, $dirId);
        }
        $dirs = $qb->getQuery()->getResult();
        return $dirs;

    }

Results to qry:

SELECT p0*.id AS id0, p0_.title AS title1, p0_.position AS position2, p0_.id_language AS id_language3, p0_.default_page_id AS default_page_id4, p0_.parent_id AS parent_id5 FROM page_directory p0_ WHERE p0*.id IS NULL // or some value

it should be:

SELECT p0*.id AS id0, p0_.title AS title1, p0_.position AS position2, p0_.id_language AS id_language3, p0_.default_page_id AS default_page_id4, p0_.parent_id AS parent_id5 FROM page_directory p0_ WHERE p0_.parent*id IS NULL  // or some value```

Originally created by @doctrinebot on GitHub (Dec 8, 2009). Jira issue originally created by user thecelavi: This function: ``` public function &getPageTreePortion($dirId = null) { $qb = $this->em->createQueryBuilder(); if (is_null($dirId)) { $qb->select('DP') ->from('Pleomorph\Entities\Core\Domain\PageDirectory', 'DP') ->where('DP.parentDirectory.id IS NULL'); } else { $qb->select('DP') ->from('Pleomorph\Entities\Core\Domain\PageDirectory', 'DP') ->where('DP.parentDirectory.id = ?1'); $qb->setParameter(1, $dirId); } $dirs = $qb->getQuery()->getResult(); return $dirs; } ``` Results to qry: ``` SELECT p0*.id AS id0, p0_.title AS title1, p0_.position AS position2, p0_.id_language AS id_language3, p0_.default_page_id AS default_page_id4, p0_.parent_id AS parent_id5 FROM page_directory p0_ WHERE p0*.id IS NULL // or some value ``` it should be: `````` SELECT p0*.id AS id0, p0_.title AS title1, p0_.position AS position2, p0_.id_language AS id_language3, p0_.default_page_id AS default_page_id4, p0_.parent_id AS parent_id5 FROM page_directory p0_ WHERE p0_.parent*id IS NULL // or some value``` ``````

admin added the Bug label 2026-01-22 12:32:12 +01:00

admin referenced this issue

2026-01-22 15:57:33 +01:00

[PR #249] [MERGED] [DCOM-93] Remove Reflection dependency from ClassMetadata #7918

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#249