On Mon, Aug 18, 2014 at 1:06 PM, <9devm...@gmail.com> wrote:
> Is it possible to annotate two different values to one QuerySet?
>
> Example queryset:
>
> Item.objects.annotate(score=Count('votes'))
Yes, simply pass it as an additional argument to annotate(). An
example from one of my projects:
shows = TVSeries.objects.all().order_by('name').annotate(
num_episodes=Count('tvepisode'),
num_episodes_with_media=Count('tvepisode__media_id'),
num_aired_episodes=Count('tvepisode__airdate'),
num_seasons=Max('tvepisode__season'))
So it counts the number of episodes, how many have media, how many
have aired, and what the maximum season is for each series.
>
> I would like every item in the above QuerySet to contain the following
> field:
>
> current_user_vote = Vote.objects.filter(user=request.user).filter(item=item)
As an aside, this can probably be written as:
current_user_vote = item.vote_set.filter(user=request.user)
>
> I tried to use annotate() two times, however it filtered out everything
> except items current user voted on.
Just use it once.
Cheers
Tom
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAFHbX1%2BM%2BbuFpGrz04HmT8n130z7%2BtauCnHBBoZL6diKM-2FDQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
