Re: GROUP BY query
Re: GROUP BY query
- Subject: Re: GROUP BY query
- From: Ramsey Gurley <email@hidden>
- Date: Tue, 07 Jun 2016 09:19:04 -0700
Doing it the EOF/Wonder way? I’m using
ERXSQLHelper.addGroupByClauseToExpression
I wrote one method to group by NSSet<EOAttribute>, then a second method that uses that one to group by a EORelationship. I’m not able to share the implementation, but it was fun to write.
On Jun 7, 2016, at 8:23 AM, Musall Maik <email@hidden> wrote:
> Hi,
>
> what's the current best practice to execute a raw query like this?
>
> SELECT COUNT(*), t0.a, t1.b
> FROM foo a INNER JOIN bar b ON a.bref = b.bkey
> WHERE …
> GROUP BY t0.a, t1.b
>
> Meaning, I don't have EOs in hand as a starting point. I've looked at ERXGroupingFetchSpecification, but the implementation seems to have been abandoned before completion.
>
> Thanks
> Maik
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden