/Python/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 vote215 views1 answer
%d%m%y python
Python
7 votes218 views2 answers
How to get the remainder of a number when dividing in python
Python
0 vote203 views1 answer
Saaaaaaaaaaaaa
Python
29 votes221 views6 answers
Python empty dataframe
Python
1 vote226 views3 answers
Convert timedelta to days
Python
4 votes217 views2 answers
Python get time milliseconds
Python
0 vote233 views1 answer
Import "dj_database_url" could not be resolved Pylance
Python
0 vote239 views1 answer
Change date format on django templates
Python Django
0 vote251 views1 answer
Autoscrapper basic code
Python
95 votes219 views6 answers
Get working directory python
Python