Sunday, August 19, 2018

doubt in annotate

input - Review.objects.values('description','user','review_type','reviewmapping__insitute').annotate(Count('description','user')).annotate(Count('review_type','reviewmapping__insitute')).count()

output - 2720

this query does not give id of 2720 objects for filter objects
for ids I use 

input - Review.objects.values('description','user','review_type','reviewmapping__insitute').annotate(Count('description','user')).annotate(Count('review_type','reviewmapping__insitute')).values_list('id',flat=True).count()

Output - 5139

it returns total objects ids

my question is how i get id of 2720 objects

 

--
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+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a13eafaa-56a5-48a4-82c2-773e94531db7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment