pistacchio pistacchio - 2 months ago 22
Python Question

Django select max id

given a standard model (called Image) with an autoset 'id', how do I get the max id?

So far I've tried:

max_id = Image.objects.all().aggregate(Max('id'))


but I get a 'id__max' Key error.

Trying

max_id = Image.objects.order_by('id')[0].id


gives a 'argument 2 to map() must support iteration' exception

Any help?

Answer

Just order by reverse id, and take the top one.

Image.objects.all().order_by("-id")[0]
Comments