/Python/Django/Django model query add annotation field to show duplicate count

Django model query add annotation field to show duplicate count

from django.db.models import OuterRef, Subquery, Count, Min

subquery = Product.objects.filter(bc_sku=OuterRef('bc_sku')).values('bc_sku')
                          .annotate(dup_count=Count('*'), min_price=Min('product_price'))
Product.objects.filter(product_type='good')
               .annotate(dup_count=Subquery(subquery.values('dup_count')), 
                         min_price=Subquery(subquery.values('min_price')))

Similar codes

1 vote199 views1 answer
How to create staff account in django
Python Django
4 votes259 views4 answers
How to change django admin text
Python Django
0 vote210 views1 answer
Django optional path parameter
Python Django
1 vote231 views2 answers
Django content type
Python Django
0 vote206 views1 answer
Django check if user is staff in template
Python Django
6 votes132 views5 answers
Manage.py", line 12, in main raise importerror( importerror: couldn't import django. are you sure it's installed and available on your pythonpath environment variable? did you forget to activate a virtual environment
Python Django
0 vote186 views1 answer
How to delete all instances of a model in django
Python Django
5 votes250 views1 answer
Q is not defined pylance django
Python Django
0 vote199 views1 answer
Merge two Querysets in Python Django while preserving Queryset methods
Python Django
0 vote179 views1 answer
Unique_together what is used of it in django
Python Django