#Can I not add multiple annotations to a queryset?

4 messages · Page 1 of 1 (latest)

wraith osprey
#

Basically, I want a simple <table> of customers with columns for the number of locations, number of devices, number of known config versions

#

Even better would be a count of devices of each type, but that's harder.

#

I guess I'm struggling both with the annotations and with traversing multiple levels of FK. getting the model on the other end of an FK is fine, but getting the model FKed to a model that's FKed to the model in the listView isn't working for me.

wraith osprey
#

I'm SQL I would join all of the tables and aggregate on locations probably.