Best way to have order_by and distinct different columns in Django?

Asked Jul 25 '18 at 07:49

Active Jul 26 '18 at 16:24

Viewed 115 times

I'm trying to do the following with a PostgreSQL DB:

team_updates = TeamUpdate.objects.filter(team__in = TeamStarred.objects.filter(user=request.user).values('team'))
team_updates = team_updates.order_by('-date','team__name').distinct('team__name')

This would technically solve the problem, but it causes the ordering to now be by team_name rather than date.

team_updates = TeamUpdate.objects.filter(team__in = TeamStarred.objects.filter(user=request.user).values('team'))
team_updates = team_updates.order_by('team__name', '-date').distinct('team__name')

edited Jul 26 '18 at 16:24

asked Jul 25 '18 at 07:49

siddhant1999

Have you checked this https://stackoverflow.com/questions/2412770/good-ways-to-sort-a-queryset-django ? – Umair Mohammad Jul 25 '18 at 08:16
Yes, that question/answer doesn't speak to the issue with having a field be distinct – siddhant1999 Jul 26 '18 at 16:24

Best way to have order_by and distinct different columns in Django?

0 Answers0