How to get max 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 max value here? In python or in the ORM?

Answer 1

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

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

Answer 2

From the documentation:

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

And to fetch the value in the template:

{{ item.added__max }}

Answer 3

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