[Answer]-Django count with filters and manytomany field

by

1👍

EDIT: I have simplified your model relationships…..

I am not sure I fully understand your models, but here is an attempt to solve your problem…

What you need to do in your models.py is define a property for each column you want in the list display, then just include it in your admin.py file.

You haven’t listed what your possible_values are, so I am guessing in the code below:

class Video(models.Model):

    '''Video model'''

    # I ADDED THIS FIELD
    title = models.CharField(max_length=255)
    # UNLESS I AM MISSING SOMETHING, YOU DON'T EVEN NEED THIS....
    # YOU ALREADY HAVE A ForeignKey RELATION IN ModerationVote....
    # votes = models.ManyToManyField(User, through='moderationVote', related_name='vt')

    @property
    def ok_votes(self):
        return self.moderationvote_set.all().filter(vote='ok').count()

    @property
    def not_ok_votes(self):
        return self.moderationvote_set.all().filter(vote='not_ok').count()

    @property
    def neutral_votes(self):
        return self.moderationvote_set.all().filter(vote='neutral').count()

    class Meta:
        ordering = ['title', ]

class ModerationVote(models.Model):

    '''ModerationVote model'''

    possible_values = ( 
        ('ok', 'ok'),
        ('not_ok', 'not_ok'),
        ('neutral', 'neutral'),
    )   

    user = models.ForeignKey(User)
    video = models.ForeignKey(Video)
    vote = models.CharField(choices=possible_values, max_length=30)
    date = models.DateTimeField(auto_now_add=True)

    def __unicode__(self):
        return '%s - %s' % (self.user, self.video)

Then in your admin.py you just call these properties like any other field:

class VideoAdmin(admin.ModelAdmin):
     # All your other admin goodness...
     list_display = ('votes',
                     'ok_votes',
                     'notok_votes',
                     'neutral_votes',
     )
👤tatlar

Leave a comment