Skip to content

Problem with Query #576

@HerrHase

Description

@HerrHase

Hello :)

There is a Problem with Quries. I have a Document Media, that have as Children different Types of Attribute-Classes. One Type referrer to Documents that represent a Tag. The Problem is the Query, to get only Media with a specific Tag I join Media with Attribute. That works and I only get Media that have Children with the Attribute-Tag-Class, BUT when I join Attribute with Tags, I get the error “Join with Joins”. But this a little bit Strange, or is there another way? Also there is no whereIn-Function to filter more than one tag on the same query.

$queryBuilder->from('p')->document('MediaBundle\Document\Media', 'p');
$queryBuilder
    ->addJoinInner()
    ->right()->document('MediaBundle\Document\Attribute\Tag', 'a')->end()
    ->condition()->child('a', 'p')->end();

$queryBuilder
    ->addJoinInner()
    ->right()->document('MediaBundle\Document\Taxon', 't')->end()
    ->condition()->equi('a.taxon', 't.uuid')->end();

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions