python - Django: How to limit number of objects returned from a model

Question

I have a list of "news" headlines in a database with the following fields: ID, Title, Date. I want to get the ten latest ones (or retrieve all of them if there are less than ten).

Something like:

news = News.objects.order_by("date").first(10)

Answer 1

This is what you need to do:

news = News.objects.order_by("-date")[:10]

There are a couple of interesting things going on here.

First, to get the lastest news, you need Descending order. (Thats the "-date" part) [0]

The second part is LIMITing the resultset[1]. This shares the same interface as Python lists Slicing[2], but those are different things. Please read them carefully.

[0] https://docs.djangoproject.com/en/dev/ref/models/querysets/#order-by

[1] https://docs.djangoproject.com/en/dev/topics/db/queries/#limiting-querysets

[2] http://docs.python.org/2/tutorial/introduction.html