I have following structure in phpcr
/foo1/foo1/childcollection1/foo1/childcollection2/foo1/childcollection3/foo2/foo2/childcollection1/foo2/childcollcetion2/foo2/childcollection3/foo2/childcollection4/foo3/foo4/foo4/childcollection1/foo4/childcollcetion2...
I need to fatch only "foo" nodes which have at least one childcollection.
Childcollection is mapped in foo document as /**
PHPCRODM\Children(fetchDepth=0) */
I was able to do it by following inner join query in my repository
$query = $this->createQueryBuilder('foo');
$query->addJoinInner()
->right()->document('Path\PathBundle\Document\Childcollection',
'c')->end()
->condition()->child('c', 'foo');
As a result I do have foo documents which have at least one childcollection
node, but when I add page functionality
$query->setMaxResults($limit);
I don't have a $limit number of documents. Result depends of number of
childcollections in foo documents.
Can anybody help me with query to fetch only nodes with at least one
childcollection and where I can add page functionality to that query.
Thanks and best regards
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/groups/opt_out.
