Re: How to make a query?

Use the 'dates' method:
https://docs.djangoproject.com/en/dev/ref/models/querysets/#dates with
"month" for the kind argument. You can filter the query first to
restrict to last five months. E.g:

>>> oldest = datetime.date.today()-datetime.timedelta(30*5) #roughly 5
months ago
>>> months = Article.objects.filter(date__gte=oldest).dates('date', 'month')

_Nik

Article.objects.filter(date__gte
On 6/27/2012 12:28 PM, galgal wrote:
> I have a model Article. It has a datetime field, title and description.
> How can I get last 5 months from now, where there is at least 1
> article added? Other words - how to get last 5 months which are not empty?
> --
> You received this message because you are subscribed to the Google
> Groups "Django users" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/django-users/-/BbMtFrpjLH4J.
> 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.


--
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.