[Answered ]-Django annotation and filtering

by

2👍

I cannot think of a way to include the boolean condition. Perhaps others can answer that better.

How about thinking a bit differently? If you don’t mind executing two queries you can filter your articles based on whether the currently logged in user has voted on them or not. Something like this:

all_articles  = Article.objects.all()

articles_user_has_voted_on = all_articles.filter(vote__caster  = 
         request.user).annotate(total_score=Sum('vote__score'))

other_articles = all_articles.exclude(vote__caster  = 
         request.user).annotate(total_score=Sum('vote__score'))

Update

After some experiments I was able to figure out how to add a boolean condition for a column in the same model (Article in this case) but not for a column in another table (Vote.caster).

If Article had a caster column:

Article.objects.all().extra(select = {'already_voted': "caster_id = %s" % request.user.id})

In the present state this can be applied for the Vote model:

Vote.objects.all().extra(select = {'already_voted': "caster_id = %s" % request.user.id})
👤Manoj Govindan

Leave a comment