Django - Getting last object created, simultaneous filters

python django filter django-views
zdyn picture zdyn · Aug 10, 2009 · Viewed 79k times · Source

Apologies, I am completely new to Django and Python.

I have 2 questions. First, how would I go about getting the last object created (or highest pk) in a list of objects? For example, I know that I could use the following to get the first object:

list = List.objects.all()[0]

Is there a way to get the length of List.objects? I've tried List.objects.length but to no avail.

Second, is it possible to create simultaneous filters or combine lists? Here is an example:

def findNumber(request, number)
    phone_list = Numbers.objects.filter(cell=number)

I want something like the above, but more like:

def findNumber(request, number)
    phone_list = Numbers.objects.filter(cell=number or home_phone=number)

What is the correct syntax, if any?

Answer

hughdbrown picture hughdbrown · Aug 10, 2009

I haven't tried this yet, but I'd look at the latest() operator on QuerySets:

latest(field_name=None)

Returns the latest object in the table, by date, using the field_name provided as the date field.

This example returns the latest Entry in the table, according to the pub_date field:

Entry.objects.latest('pub_date')

If your model's Meta specifies get_latest_by, you can leave off the field_name argument to latest(). Django will use the field specified in get_latest_by by default.

Like get(), latest() raises DoesNotExist if an object doesn't exist with the given parameters.

Note latest() exists purely for convenience and readability.

And the model docs on get_latest_by:

get_latest_by

Options.get_latest_by

The name of a DateField or DateTimeField in the model. This specifies the default field to use in your model Manager's latest method.

Example:

get_latest_by = "order_date"

See the docs for latest() for more.

Edit: Wade has a good answer on Q() operator.

Related questions

How can I filter a date of a DateTimeField in Django?

I am trying to filter a DateTimeField comparing with a date. I mean: MyObject.objects.filter(datetime_attr=datetime.date(2009,8,22)) I get an empty queryset list as an answer because (I think) I am not considering time, but I want "…

Read More
Django filter queryset __in for *every* item in list

Let's say I have the following models class Photo(models.Model): tags = models.ManyToManyField(Tag) class Tag(models.Model): name = models.CharField(max_length=50) In a view I have a list with active filters called categories. I want to filter …

Read More
Django Admin filter on Foreign Key property

I want to add a filter in an admin changelist by a property of a foreign key, e.g. class Address(model.Models): street = models.CharField(max_length=25) city = models.CharField(max_length=25) country = models.CharField(max_length=25) class Customer(…

Read More