/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 vote141 views1 answer
Matplotlib: use colormaps for line plot colors
Python
0 vote146 views1 answer
Django optional path parameter
Python
0 vote144 views1 answer
Python if type dict
Python
0 vote148 views1 answer
No lapack/blas resources found scipy
Python
62 votes156 views6 answers
Sort dictionary by values
Python
0 vote155 views1 answer
ModuleNotFoundError: No module named 'boto3'
Python
0 vote160 views1 answer
How to make a instagram report bot python
Python
3 votes153 views1 answer
Python split lines
Python
0 vote149 views1 answer
Off to obj python
Python
0 vote152 views2 answers
Operator in django query
Python Django