/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 vote210 views1 answer
Color module python
Python
2 votes192 views1 answer
How to clear an array python
Python
18 votes209 views6 answers
Turtle python
Python
21 votes191 views6 answers
How to concatenate two lists in python
Python
0 vote186 views1 answer
Los mejores script de phython
Python
0 vote170 views1 answer
When button is clicked tkinter python
Python
0 vote185 views1 answer
** (ArgumentError) lists in Phoenix.HTML and templates may only contain integers representing bytes, binaries or other lists, got invalid entry:
Python
2 votes334 views1 answer
Python split string by tab
Python
0 vote188 views1 answer
Get length of a tuple in python
Python
7 votes131 views1 answer
How to check if an application is open in python
Python