doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-04-29 17:33:15 +02:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

DQL using INSTANCE OF with parameters return no results #5563

New Issue
Closed
opened 2026-01-22 15:11:23 +01:00 by admin · 7 comments
admin commented 2026-01-22 15:11:23 +01:00
Owner
Copy Link
Copy Source

Originally created by @courtney-miles on GitHub (Jun 2, 2017).

Originally assigned to: @Ocramius on GitHub.

If I defined the following DQL and it returns the expected results.

$dql = <<<DQL
SELECT o FROM \MyProj\AbstractMyObject AS o 
WHERE o INSTANCE OF \MyProj\AlphaObject
DQL;
$q = $this->getEntityManager()->createQuery($dql);
$q->getResult(); // 1 row returns

However, when I supply the instance name as a parameter I get no results.

$dql = <<<DQL
SELECT o FROM \MyProj\AbstractMyObject AS o 
WHERE o INSTANCE OF :type
DQL;
$q = $this->getEntityManager()->createQuery($dql);
$q->setParameter(
    'type',
    '\MyProj\AlphaObject'
);
$q->getResult(); // 0 row returns

What could I be doing wrong? Or how can I can I debug this? I know to get the query with $q->getSQL(), but I can't see how to confirm exactly what value it resolves for use with the parameterised query.

I have also tried using \MyProj\AlphaObject::class and combinations beginning without the slash. Ultimately I'm looking to supply an array types, which also does not work, so I'm focusing on getting one parameter to work first.

These are the versions of the various doctrine packages I am using.

doctrine/annotations               v1.2.7  Docblock Annotations Parser
doctrine/cache                     v1.6.0  Caching library offering an object-oriented API for many cache ba...
doctrine/collections               v1.3.0  Collections Abstraction library
doctrine/common                    v2.6.1  Common Library for Doctrine projects
doctrine/dbal                      v2.5.5  Database Abstraction Layer
doctrine/inflector                 v1.1.0  Common String Manipulations with regard to casing and singular/pl...
doctrine/instantiator              1.0.5   A small, lightweight utility to instantiate objects in PHP withou...
doctrine/lexer                     v1.0.1  Base library for a lexer that can be used in Top-Down, Recursive ...
doctrine/orm                       v2.5.6  Object-Relational-Mapper for PHP```
Originally created by @courtney-miles on GitHub (Jun 2, 2017). Originally assigned to: @Ocramius on GitHub. If I defined the following DQL and it returns the expected results. ```php $dql = <<<DQL SELECT o FROM \MyProj\AbstractMyObject AS o WHERE o INSTANCE OF \MyProj\AlphaObject DQL; $q = $this->getEntityManager()->createQuery($dql); $q->getResult(); // 1 row returns ``` However, when I supply the instance name as a parameter I get no results. ```php $dql = <<<DQL SELECT o FROM \MyProj\AbstractMyObject AS o WHERE o INSTANCE OF :type DQL; $q = $this->getEntityManager()->createQuery($dql); $q->setParameter( 'type', '\MyProj\AlphaObject' ); $q->getResult(); // 0 row returns ``` What could I be doing wrong? Or how can I can I debug this? I know to get the query with `$q->getSQL()`, but I can't see how to confirm exactly what value it resolves for use with the parameterised query. I have also tried using `\MyProj\AlphaObject::class` and combinations beginning without the slash. Ultimately I'm looking to supply an array types, which also does not work, so I'm focusing on getting one parameter to work first. These are the versions of the various doctrine packages I am using. ``` doctrine/annotations v1.2.7 Docblock Annotations Parser doctrine/cache v1.6.0 Caching library offering an object-oriented API for many cache ba... doctrine/collections v1.3.0 Collections Abstraction library doctrine/common v2.6.1 Common Library for Doctrine projects doctrine/dbal v2.5.5 Database Abstraction Layer doctrine/inflector v1.1.0 Common String Manipulations with regard to casing and singular/pl... doctrine/instantiator 1.0.5 A small, lightweight utility to instantiate objects in PHP withou... doctrine/lexer v1.0.1 Base library for a lexer that can be used in Top-Down, Recursive ... doctrine/orm v2.5.6 Object-Relational-Mapper for PHP```
admin added the Question label 2026-01-22 15:11:23 +01:00
admin closed this issue 2026-01-22 15:11:23 +01:00
admin commented 2026-01-22 15:11:24 +01:00
Author
Owner
Copy Link
Copy Source

@Ocramius commented on GitHub (Jun 2, 2017):

Try binding $em->getClassMetadata(AlphaObject::class);

On 2 Jun 2017 05:28, "courtney-miles" notifications@github.com wrote:

If I defined the following DQL, it returns the expected results.

$dql = <<<DQLSELECT o FROM \MyProj\AbstractMyObject AS o WHERE o
INSTANCE OF \MyProj\AlphaObjectDQL;$q =
$this->getEntityManager()->createQuery($dql);$q->getResult(); // 1 row
returns

However, when I supply the instance name as a parameter I get no results.

$dql = <<<DQLSELECT o FROM \MyProj\AbstractMyObject AS o WHERE o
INSTANCE OF :typeDQL;$q =
$this->getEntityManager()->createQuery($dql);$q->setParameter(
'type', '\MyProj\AlphaObject');$q->getResult(); // 0 row returns

What could I be doing wrong? Or how can I can I debug this? I know to get
the query with $q->getSQL(), but I can't see how to confirm exactly what
value it resolves for use with the parameterised query.

I have also tried using \MyProj\AlphaObject::class and combinations
beginning without the slash. Ultimately I'm looking to supply an array
types, which also does not work, so I'm focusing on getting one parameter
to work first.

This are the versions of the various doctrine packages.

doctrine/annotations v1.2.7 Docblock Annotations Parser
doctrine/cache v1.6.0 Caching library offering an
object-oriented API for many cache ba...
doctrine/collections v1.3.0 Collections Abstraction library
doctrine/common v2.6.1 Common Library for Doctrine projects
doctrine/dbal v2.5.5 Database Abstraction Layer
doctrine/inflector v1.1.0 Common String Manipulations
with regard to casing and singular/pl...
doctrine/instantiator 1.0.5 A small, lightweight
utility to instantiate objects in PHP withou...
doctrine/lexer v1.0.1 Base library for a lexer
that can be used in Top-Down, Recursive ...
doctrine/orm v2.5.5 Object-Relational-Mapper for PHP

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/doctrine/doctrine2/issues/6483, or mute the thread
https://github.com/notifications/unsubscribe-auth/AAJakA5nQpaWPX3E5V99uA2Dp_JMkosPks5r_4FVgaJpZM4NtyfU
.

@Ocramius commented on GitHub (Jun 2, 2017): Try binding `$em->getClassMetadata(AlphaObject::class);` On 2 Jun 2017 05:28, "courtney-miles" <notifications@github.com> wrote: If I defined the following DQL, it returns the expected results. $dql = <<<DQLSELECT o FROM \MyProj\AbstractMyObject AS o WHERE o INSTANCE OF \MyProj\AlphaObjectDQL;$q = $this->getEntityManager()->createQuery($dql);$q->getResult(); // 1 row returns However, when I supply the instance name as a parameter I get no results. $dql = <<<DQLSELECT o FROM \MyProj\AbstractMyObject AS o WHERE o INSTANCE OF :typeDQL;$q = $this->getEntityManager()->createQuery($dql);$q->setParameter( 'type', '\MyProj\AlphaObject');$q->getResult(); // 0 row returns What could I be doing wrong? Or how can I can I debug this? I know to get the query with $q->getSQL(), but I can't see how to confirm exactly what value it resolves for use with the parameterised query. I have also tried using \MyProj\AlphaObject::class and combinations beginning without the slash. Ultimately I'm looking to supply an array types, which also does not work, so I'm focusing on getting one parameter to work first. This are the versions of the various doctrine packages. doctrine/annotations v1.2.7 Docblock Annotations Parser doctrine/cache v1.6.0 Caching library offering an object-oriented API for many cache ba... doctrine/collections v1.3.0 Collections Abstraction library doctrine/common v2.6.1 Common Library for Doctrine projects doctrine/dbal v2.5.5 Database Abstraction Layer doctrine/inflector v1.1.0 Common String Manipulations with regard to casing and singular/pl... doctrine/instantiator 1.0.5 A small, lightweight utility to instantiate objects in PHP withou... doctrine/lexer v1.0.1 Base library for a lexer that can be used in Top-Down, Recursive ... doctrine/orm v2.5.5 Object-Relational-Mapper for PHP — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <https://github.com/doctrine/doctrine2/issues/6483>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAJakA5nQpaWPX3E5V99uA2Dp_JMkosPks5r_4FVgaJpZM4NtyfU> .
admin commented 2026-01-22 15:11:24 +01:00
Author
Owner
Copy Link
Copy Source

@courtney-miles commented on GitHub (Jun 2, 2017):

Try binding $em->getClassMetadata(AlphaObject::class);

I have given that a go, but it does not appear to have helped.

This is my resulting code.

$dql = <<<DQL
SELECT o FROM \MyProj\AbstractMyObject AS o 
WHERE o INSTANCE OF :type
DQL;
$this->getEntityManager()->getClassMetadata(AlphaObject::class);
$q = $this->getEntityManager()->createQuery($dql);
$q->setParameter(
    'type',
    '\MyProj\AlphaObject'
);
$q->getResult(); // 0 row returns

In case it matters, this is triggered from within an Entity Repository method.

@courtney-miles commented on GitHub (Jun 2, 2017): > Try binding `$em->getClassMetadata(AlphaObject::class);` I have given that a go, but it does not appear to have helped. This is my resulting code. ```php $dql = <<<DQL SELECT o FROM \MyProj\AbstractMyObject AS o WHERE o INSTANCE OF :type DQL; $this->getEntityManager()->getClassMetadata(AlphaObject::class); $q = $this->getEntityManager()->createQuery($dql); $q->setParameter( 'type', '\MyProj\AlphaObject' ); $q->getResult(); // 0 row returns ``` In case it matters, this is triggered from within an Entity Repository method.
admin commented 2026-01-22 15:11:24 +01:00
Author
Owner
Copy Link
Copy Source

@Ocramius commented on GitHub (Jun 2, 2017):

$dql = <<<DQL
SELECT o FROM \MyProj\AbstractMyObject AS o 
WHERE o INSTANCE OF :type
DQL;
$q = $this->getEntityManager()->createQuery($dql);
$q->setParameter(
    'type',
    $this->getEntityManager()->getClassMetadata(AlphaObject::class);
);
$q->getResult();
@Ocramius commented on GitHub (Jun 2, 2017): ```php $dql = <<<DQL SELECT o FROM \MyProj\AbstractMyObject AS o WHERE o INSTANCE OF :type DQL; $q = $this->getEntityManager()->createQuery($dql); $q->setParameter( 'type', $this->getEntityManager()->getClassMetadata(AlphaObject::class); ); $q->getResult(); ```
admin commented 2026-01-22 15:11:24 +01:00
Author
Owner
Copy Link
Copy Source

@courtney-miles commented on GitHub (Jun 7, 2017):

Thank you @Ocramius. This works. Apologies for my lack of understanding on how getClassMetadata() is used.

So the last thing I can't figure out it how to get this to work with 2 or more instances.

So this is what I'm trying.

$dql = <<<DQL
SELECT o FROM \MyProj\AbstractMyObject AS o 
WHERE o INSTANCE OF (:types)
DQL;
$q = $this->getEntityManager()->createQuery($dql);
$q->setParameter(
    'types',
    [
        $this->getEntityManager()->getClassMetadata(AlphaObject::class),
        $this->getEntityManager()->getClassMetadata(BetaObject::class)
    ]
);
$q->getResult();

I was given the impression somewhere supplying an array would work, but can't find where now.

Thanks again for your help so far.

@courtney-miles commented on GitHub (Jun 7, 2017): Thank you @Ocramius. This works. Apologies for my lack of understanding on how `getClassMetadata()` is used. So the last thing I can't figure out it how to get this to work with 2 or more instances. So this is what I'm trying. ```php $dql = <<<DQL SELECT o FROM \MyProj\AbstractMyObject AS o WHERE o INSTANCE OF (:types) DQL; $q = $this->getEntityManager()->createQuery($dql); $q->setParameter( 'types', [ $this->getEntityManager()->getClassMetadata(AlphaObject::class), $this->getEntityManager()->getClassMetadata(BetaObject::class) ] ); $q->getResult(); ``` I was given the impression somewhere supplying an array would work, but can't find where now. Thanks again for your help so far.
admin commented 2026-01-22 15:11:25 +01:00
Author
Owner
Copy Link
Copy Source

@trickeyone commented on GitHub (Jul 14, 2017):

I've found that trying to use INSTANCE OF with a parameter doesn't work. The parameter is bound with the values given (i.e. the actual class name) instead of the discriminator type value.

So, this:

$dql = <<<DQL
SELECT o FROM \MyProj\AbstractMyObject AS o 
WHERE o INSTANCE OF (:types)
DQL;
$q = $this->getEntityManager()->createQuery($dql);
$q->setParameter(
    'types',
    [
        $this->getEntityManager()->getClassMetadata(AlphaObject::class),
        $this->getEntityManager()->getClassMetadata(BetaObject::class)
    ]
);

Will result in this kind of SQL query:

SELECT <fields> FROM my_object o WHERE o.<discriminator_column> IN (:types)

And the types parameter will be the below instead of the discriminator type values:

[
    'MyProj\AlphaObject',
    'MyProj\BetaObject',
]

I usually have to do the following to get it to work:

$dql = "SELECT o FROM \MyProj\AbstractMyObject AS o " .
    "WHERE o INSTANCE OF " . AlphaObject::class . " OR o INSTANCE OF " . BetaObject::class;

Doing this, the discriminator types are properly determined.

@trickeyone commented on GitHub (Jul 14, 2017): I've found that trying to use `INSTANCE OF` with a parameter doesn't work. The parameter is bound with the values given (i.e. the actual class name) instead of the discriminator type value. So, this: ``` $dql = <<<DQL SELECT o FROM \MyProj\AbstractMyObject AS o WHERE o INSTANCE OF (:types) DQL; $q = $this->getEntityManager()->createQuery($dql); $q->setParameter( 'types', [ $this->getEntityManager()->getClassMetadata(AlphaObject::class), $this->getEntityManager()->getClassMetadata(BetaObject::class) ] ); ``` Will result in this kind of SQL query: ``` SELECT <fields> FROM my_object o WHERE o.<discriminator_column> IN (:types) ``` And the `types` parameter will be the below instead of the discriminator type values: ``` [ 'MyProj\AlphaObject', 'MyProj\BetaObject', ] ``` I usually have to do the following to get it to work: ```php $dql = "SELECT o FROM \MyProj\AbstractMyObject AS o " . "WHERE o INSTANCE OF " . AlphaObject::class . " OR o INSTANCE OF " . BetaObject::class; ``` Doing this, the discriminator types are properly determined.
admin commented 2026-01-22 15:11:28 +01:00
Author
Owner
Copy Link
Copy Source

@Ocramius commented on GitHub (Jul 22, 2017):

@courtney-miles INSTANCE OF accepts a single value: you tried to use it like an IN() expression

@Ocramius commented on GitHub (Jul 22, 2017): @courtney-miles `INSTANCE OF` accepts a single value: you tried to use it like an `IN()` expression
admin commented 2026-01-22 15:11:29 +01:00
Author
Owner
Copy Link
Copy Source

@Ocramius commented on GitHub (Jul 22, 2017):

Closing here, as all questions were fully answered. If you think that the documentation could be improved, please send a patch there.

@Ocramius commented on GitHub (Jul 22, 2017): Closing here, as all questions were fully answered. If you think that the documentation could be improved, please send a patch there.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
BC Break
Bug
Can't Fix
Deprecation
Documentation
DQL
Duplicate
Failing Test
Hacktoberfest
Improvement
Improvement
Incomplete
Invalid
Missing Tests
New Feature
PR Created
pull-request
Mirrored from GitHub Pull Request
 Question
Regression
Status: Waiting feedback
Waiting feedback
WIP
Won't Fix
No Label Question
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5563
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?