django annotate queryset based on attribute

Question

is there a way to do the following in one Django query?

MyModel.filter(attr=a).values('attr','fields','of','interest').annotate(count=Count('id'))
MyModel.filter(attr=b).values('attr','fields','of','interest').annotate(count=Count('id'))

edit: I need separate counts for a and b. MyModel.filter(attr__in=(a,b))... or MyModel.filter(Q(attr=a)|Q(attr=b))... won't work I guess.

istruble · Accepted Answer · 2010-03-09 16:41:06Z

4

Your MyModel class may have an order_by value set to order on something not in ('attr','fields','of','interest'). Try removing the ordering or ordering by one or more of the fields of interest.

MyModel.objects.values('attr','fields','of','interest'
        ).annotate(count=Count('id')).order_by()

answered Mar 9, 2010 at 16:41

istruble

13.8k2 gold badges51 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

django annotate queryset based on attribute

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related