Sorry, only now I see you posed the same question in another thread again:
doen't do that, please. I'll read that and answer there.
On Friday, 14 February 2014 07:14:58 UTC+1, Herman Peeren wrote:
>
> Is id the primary key of R? Then this query returns a collection of
> distinct R-entities and there is nothing to group.
> Could you give an example with some simple data, the result and your
> expected result?
>
> On Thursday, 13 February 2014 20:42:30 UTC+1, Parsifal wrote:
>>
>> entity r is ManyToOne with entity i, and entity i is OneToMany to entity
>> r.
>> Now I have this:
>> $query = $em->createQuery("SELECT x, y.optVar1, FROM Entities\R x JOIN
>> x.I y WHERE (x.productId = :n AND x.key = :f) GROUP BY x.id");
>> It works fine, just GROUP BY is not working, it returns the array just
>> like there is no GROUP BY, in order to fix it, what else should I care
>> when mapping the two entities with each other?
>>
>
--
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.
