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
How can I force using having when I can't define the param in
annotate?
Thanks in advance,
Luis
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
