I ran in a little problems by using the filter NOR on user roles.
filtering to users which are not in role R will not list users, that don't have any role!

I've attached a patch which fixed the problem for me.

CommentFileSizeAuthor
#2 views_filteringjoins_rerolled.patch.txt1.16 KBfago
#1 views_query_v1-20.diff.txt925 bytesDave Cohen
views_filteringjoins.patch.txt1.13 KBfago

Comments

Dave Cohen’s picture

Dave Cohen commented
StatusFileSize
new views_query_v1-20.diff.txt925 bytes

In trying to write a workaround for my problem http://drupal.org/node/74713 (still not a duplicate of this bug),
I encountered exactly the same problem as fago. So I say +1 to this fix.

I'm working off a different revision of views_query.inc. Mine is probably out of date, but just in case it's useful, I'm attaching the same patch against revision 1.20 of views_query.inc.

fago’s picture

fago
Primary language German
Location Vienna
commented
StatusFileSize
new views_filteringjoins_rerolled.patch.txt1.16 KB

i noticed that my patch made use of some tabs, so I replaced them with spaces and rerolled the patch.

merlinofchaos’s picture

merlinofchaos commented
Status: Needs review » Fixed

Committed. I didn't test this myself, but it looks like it's been well covered.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)