Hello guys, I have the following queryset:
subscribers = User.objects.values('email', 'username').filter(
Q(subscription_settings__new_question='i') |
Q(subscription_settings__new_question_watched_tags='i',
marked_tags__id__in=question.tags.values('id'),
tag_selections__reason='good')
).exclude(id=question.author.id)
The problem is that when I evaluate the query I get only the values
that are filtered by the first Q object (even if I reverse the order
of the objects). So lets say that I was expecting the user A, B, C and
D, where A and B are filtered by the first Q object and C and D by the
second. But the queryset only returns A and B.
I used the django debug toolbar to see the query that was actually
being executed (and then I used a direct print statement like "print
subscriber.query.as_sql()" just to be sure) and then evaluated the
query directly using psql (I'm using postgres by the way), and I get
the results I expect.
Here's the query btw:
SELECT "auth_user"."email", "auth_user"."username" FROM "auth_user"
LEFT OUTER JOIN "forum_markedtag" ON ("auth_user"."id" =
"forum_markedtag"."user_id") INNER JOIN
"forum_defaultsubscriptionsetting" ON ("auth_user"."id" =
"forum_defaultsubscriptionsetting"."user_id") WHERE
((("forum_markedtag"."reason" = E'good' AND
"forum_defaultsubscriptionsetting"."new_question_watched_tags" = E'i'
AND "forum_markedtag"."tag_id" IN (SELECT U0."id" FROM "tag" U0 INNER
JOIN "question_tags" U1 ON (U0."id" = U1."tag_id") WHERE
U1."question_id" = 64 )) OR
"forum_defaultsubscriptionsetting"."new_question" = E'i' ) AND NOT
("auth_user"."id" = 10 ))
Thanks,
Hernâni
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
