/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

0 vote350 views1 answer
Get current url with parameters url django
Python Django
0 vote310 views2 answers
Django edit object foreign key id
Python Django
3 votes332 views1 answer
File manage py line 17 from exc django
Python Django
0 vote297 views1 answer
Csrf token fetch django
Python Django
2 votes335 views2 answers
Create django user command line
Python Django
1 vote355 views1 answer
Passing user instance django form submission
Python Django
0 vote305 views1 answer
Get users except superuser django
Python Django
0 vote357 views1 answer
How to create urls in django
Python Django
0 vote343 views1 answer
Foreign key django createview
Python Django
0 vote338 views1 answer
?: (admin.W411) 'django.template.context_processors.request' must be enabled in DjangoTemplates (TEMPLATES) in order to use the admin navigation sidebar.
Python Django