Django - ORM - Find duplicate objects based on a specific field

django_find_duplicate_objects.py

"""
Suppose you have a django model called MyModel with a field called 'name'.
If for some reason you did not set a "unique" constraint on that field but would still like to avoid duplicate objects with teh same name,
here is how to find all the duplicate objects based on that "name" field.
"""
duplicate_names = MyModel.objects.values('name', 'id').annotate(Count('name')).order_by().filter(name__count__gt=1)

# You can then retrieve all these duplicate objects using this query:
duplicate_objects = MyModel.objects.filter(id__in=[item['id'] for item in duplicate_names])

ids = MyModel.objects.values('name', 'id').annotate(Count('name')).order_by().filter(name__count__gt=1).values_list("id", flat=True)

duplicate_objects = MyModel.objects.filter(id__in=ids)

from django.db.models import Count