How can I annotate a Django queryset with a count in a way that's conditional to some property of each item in the queryset? -


sorry title, think pseudo-code clarify question:

class image(model):     user = foreignkey(user)  class group(model):     members = foreignkey(user)     images = foreignkey(image)     autosubmission = booleanfield() 

as can see, have group, consisting of members , images.

if group autosubmission members don't submit images manually it, images belonging member automatically show in group.

if group not autosubmission members need submit images manually, , end in images foreignkey.

now, want have queryset that's annotated number of images the group.

group.objects.all().annotate(num_images = count('images')) 

obviously, code above works groups not autosubmission, i.e. images in images relation.

so how can annotate queryset works both groups autosubmission , groups not?

thanks!


Comments

Popular posts from this blog

javascript - Thinglink image not visible until browser resize -

firebird - Error "invalid transaction handle (expecting explicit transaction start)" executing script from Delphi -

mongodb - How to keep track of users making Stripe Payments -