/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

3 votes126 views1 answer
How to find the multiples of a number in python
Python
7 votes125 views2 answers
Calculate the addition of two lists in python
Python
0 vote81 views2 answers
Video to text python
Python
0 vote127 views1 answer
Longueur array python
Python
5 votes121 views6 answers
How to check a string in if statement python
Python
0 vote127 views1 answer
How to write in google chrome console in python
Python
0 vote131 views1 answer
Python tags
Python
0 vote141 views1 answer
How to make booking website using django step by step
Python
0 vote135 views1 answer
Export an excel table to image with python
Python
0 vote125 views1 answer
Php echo shorthand example
Python