How to get maximum value in django ORM

Question

>>> AuthorizedEmail.objects.filter(group=group).values('added') [{'added': datetime.datetime(2012, 5, 19, 13, 8, 7)}, {'added': datetime.datetime(2012, 5, 19, 13, 8, 7)}, {'added': datetime.datetime(2012, 5, 19, 13, 7, 23)}, {'added': datetime.datetime(2012, 5, 19, 13, 8, 7)}] 

What would be the best way to get the maximum value here? In python or in ORM?

Answer 1

 >>> from django.db.models import Max >>> AuthorizedEmail.objects.all().aggregate(Max('added')) 

And to get the value in the template:

 {{ item.added__max }} 

Answer 2

 AuthorizedEmail.objects.filter(group=group).order_by('-added')[0] 

Answer 3

https://docs.djangoproject.com/en/dev/topics/db/aggregation/

https://docs.djangoproject.com/en/dev/topics/db/aggregation/#cheat-sheet

Answer 4

latest returns the last object in the table according to the date added :

 AuthorizedEmail.objects.filter(group=group).latest('added')