Django models, queryset using get_FOO_display() -

Django models, queryset using get_FOO_display() -

consider django model contains charfield choices.

i know can do:

product.objects.values('product_code').annontate(count=count('product_code'))

but consider 'product_code' has choices, how can have queryset homecoming result of get_product_code_display() , count of them?

you can distinct.

product.objects.values('product_code').distinct().annontate(count=count('product_code'))

django django-views django-rest-framework