Monday, September 13, 2010

Re: db filter comparing a minimum to a range

Curiously, if I add another constraint to the dates, it must go into
the Min() itself:

Blog.objects.annotate(min_date=
Min('comment__date', comment__status='sane')).all()

Otherwise the date range check is disjoint from the sanity check
(important for modern commenters!), and lots of records get missed...

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment