How do I filter query range objects by id primary_key? Django

Viewed 66

How I can filter 5 articles latest by slidenumber field.?

class Article(models.Model):
    slidenumber = models.AutoField(primary_key=True)
    title = models.CharField(max_length=255)
    category = models.CharField(default='', max_length=30)
    description = models.TextField(default="Mo ta")
    bodyrichtext= RichTextField(default="", null=True)
3 Answers

You can do that as follow (descending) :

Article.objects.all().order_by('-slidenumber')[:5]

Ascending:

Article.objects.all().order_by('slidenumber')[:5]

You can use "pk" instead of "slidenumber" since it is a primary key

Documentation for queries

I think you are asking how to order articles? I don't see a field that allows you to get "latest" or any time derived info?

      Article.objects.all().order_by('-slidenumber')

You can obtain the last five items by slicing with:

Article.objects.order_by('-slidenumber')[:5]

The [:5] will thus retrieve only the first five items for a QuerySet that ordered the Articles in descending order by slidenumber.

Related