Skip to content

Instantly share code, notes, and snippets.

@astyfx

astyfx/Django ORM filter only minimum model result by duplication field value

Last active August 29, 2015 14:05
Show Gist options
  • Save astyfx/391e4d7216d88318f99e to your computer and use it in GitHub Desktop.
Save astyfx/391e4d7216d88318f99e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Django ORM filter only minimum model result by duplication field value
filtered = [x['min_field'] for x in Model.objects.filter(filter_conditions).values('same_field').annotate(Count('same_field', distinct=True)).annotate(min_field=Min('min_field')).distinct()]
result = Model.objects.filter(field__in=filtered)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment