How to get date sorted distinct by foreignkey?

Question

Django

In [102]: Episode.objects.order_by('-date_modified').filter(series__series_type='series').values_list('series_id', flat=True).distinct()
Out[102]: [71L, 181L, 181L, 411L, 411L, 411L, 411L, 411L, 411L, 411L, 411L, 411L, 411L, 411L, 411L, 411L, 411L, 401L, 401L, 401L, '...(remaining elements truncated)...']

Where series_id foreign key.

Answer 1

This is how I got a list of unique ids sorted by date.

list(Episode.objects.values_list(
                'series_id', flat=True
            ).filter(
                series__series_type='series'
            ).annotate(
                Max("date_modified")
            ).order_by(
                '-date_modified__max'
            ))

Answer 2

https://docs.djangoproject.com/en/1.7/ref/models/q...