Get the latest filter entry in Django

Question

I am trying to get the last object of the Django model, but cannot succeed.

None of them work:

obj = Model.objects.filter(testfield=12).latest() 

 obj = Model.objects.latest().filter(testfield=12) 

Answer 1

 obj= Model.objects.filter(testfield=12).order_by('-id')[0] 

Answer 2

See django docs: https://docs.djangoproject.com/en/dev/ref/models/querysets/#latest

You need to specify the field in the last (). eg.

 obj= Model.objects.filter(testfield=12).latest('testfield') 

Or, if your Meta models specify get_latest_by, you can leave the field_name argument to earliest() or latest() . By default, Django will use the field specified in get_latest_by .

Answer 3

latest really designed to work with date fields (it probably also works with other totally ordered types, but not sure). And the only way you can use it without specifying a field name is to set the get_latest_by meta attribute, as mentioned here .

Answer 4

last () last ()

Use the last ():

 ModelName.objects.last() 

using latest ():

 ModelName.objects.latest('id') 

Answer 5

obj= Model.objects.filter(testfield=12).order_by('-id')[:1] is the right solution