On Wed, Aug 12, 2009 at 5:50 AM, lfrodrigues<lfrodrig...@gmail.com> wrote:
>
> Hi,
>
> I'm having some problems with "having":
>
> I want to group by date and restrict to a given week, in my tests I
> can do this:
> select_data = {"d": """date_format(date, '%%U')"""}
> ScoreHistory.objects.extra(select=select_data).values('d').annotate
> (l=Sum("points")).filter(l=2).query.as_sql()
>
> sql:
> SELECT (date_format(date, '%%U')) AS `d`, SUM
> (`profile_scorehistory`.`points`) AS `l` FROM `profile_scorehistory`
> GROUP BY date_format(date, '%%U') HAVING SUM
> (`profile_scorehistory`.`points`) = 2
>
> Good but what I want to get is this:
> sql:
> SELECT (date_format(date, '%%U')) AS `d`, SUM
> (`profile_scorehistory`.`points`) AS `l` FROM `profile_scorehistory`
> GROUP BY date_format(date, '%%U') HAVING `d`= 2
I might be missing something here, but as far as I can make out,
you're getting exactly what you've asked for. Your query contains
filter(l=2) - that is, you're filtering on l, the SUM.
> How can I force using having when I can't define the param in
> annotate?
I'm afraid I don't see how this relates to your original question.
Yours,
Russ Magee %-)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
