[Flow] Query on OneToMany relation

[Zedd]

Uhm,

this should work out of the box (sorry Christian :D). The issue here seems to be the orderings.

This is wrong (actually, it's sorting by 'start', then by 'ASC'):
->setOrderings(array(
   ’start', \TYPO3\Flow\Persistence\QueryInterface::ORDER_ASCENDING
))

Try this instead (notice that the property is the key, the direction the value):
->setOrderings(array(
   ’start' => \TYPO3\Flow\Persistence\QueryInterface::ORDER_ASCENDING
))

Additionally, you might want to consider using the models identifier instead of passing the object directly to QueryObject::equals. While it doesn't break for "equals", it might when using "in" or "contains".

Greetings,
Philipp Maier

On Apr 26, 2014, at 7:53 PM, Christian Müller <christian.mueller at typo3.org> wrote:

> Hi Alexander,
> 
>> $query = $this->createQuery();
>>         $result = $query->matching(
>>                     $query->logicalAnd(
>>                         $query->equals('attendees.member', $member),
> 
>> Is it even possible without using SQL syntax?
> 
> 
> No, for this type of question you need to use a DQL query because you need to join the attendees and then query for member...
> Cheers,
> Christian
> _______________________________________________
> Flow mailing list
> Flow at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow