Problem with Query

[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();

[dantleech]

Maybe you could try the other syntax (i.e. do not use addJoinInner) and add your join under the ->left() node?

[HerrHase]

Ahhh, reading saves time, i hadn't realized that he throws a "Jackalope\NotImplementedException" sorry, it's my fault. Any Idea when this Feature will be implemented?

[dantleech]

Which implementation are you using? doctrine-dbal or jackrabbit?

[HerrHase]

doctrine-dbal

[dantleech]

You might try the jackrabbit implementation, which I guess should support this. I am not sure how much work is would be to support joining joins in doctrine-dbal /cc @dbu @lsmith77

Although, have you considered a different approach?

If Attribute is a subtype of Tag you can simply join Tag and you should get both Attribute and Tag documents.

[HerrHase]

I think that will not work, the Problem is that each Attribute-Class has a body variable that has a another implementation. For the AttributeTag-Class is refers to Tags. But Thanks for your help, i will try a workaround and hope that joining joins will be implemented.

/**
 * @PHPCR\Referrers(
 *   referringDocument="MediaBundle\Document\Taxon",
 *   referencedBy="contents"
 * )
*/
protected $body;

[dbu]

@bjoernhase did you find a workaround? @dantleech does this isse need to stay open, is this something not implemented? but if jackalope-jackrabbit does not work, i guess its rather a limitation of the SQL2 specification?

[dantleech]

The SQL2 specification supports it.

The following query works on Jackrabbit, but not on Doctrine-Dbal:

SELECT * FROM [nt:unstructured] AS a 
    INNER JOIN [nt:unstructured] AS b ON ISCHILDNODE(b,a) 
    INNER JOIN [nt:unstructured] AS c ON ISCHILDNODE(c,b);

[dbu]

so should this be an issue on https://github.com/jackalope/jackalope-doctrine-dbal? if so, can you create it there with a good description dan?

[dantleech]

Hmm, not sure. It is the parser (phpcr-utils which does not parse the query). I don't know if doctrine-dbal supports it or not. Will create an issue there.

[dantleech]

See phpcr/phpcr-utils#140

[HerrHase]

@dbu yes, i have, but it is not a really good one. I have create a array that contains the uuid of each object in taxons. Each Time Taxons will be upated the array will be synchronize.

[dbu]

closing due to inactivity