When I tried to create a view that filtered nodes by term and by space (using a vocabulary for my spaces), I found that I was not seeing any nodes. Upon further digging, I discovered that the following query was being constructed (I was able to see this query by going to edit the view and prefacing the URL with the appropriate space term name):

SELECT node.nid AS nid
 FROM node node 
 LEFT JOIN term_node term_node ON node.vid = term_node.vid
 WHERE (node.type in ('page')) AND (term_node.tid = 1) AND (term_node.tid = 7)

It should be doing this:

SELECT node.nid AS nid
 FROM node node 
 INNER JOIN term_node term_node ON node.vid = term_node.vid
 LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid AND term_node2.tid != 7
 WHERE (node.type in ('page')) AND (term_node.tid = 7) AND (term_node2.tid = 1)

I'm not really sure at present how to go about fixing this, but I may dig around a bit and see if a patch becomes immediately obvious.

Comments

mnlund’s picture

I don't know if this is related but in 6.x-3.0-beta3 I found that space SID is used to create the views filter.
Take a look here to see if it's worth checking: http://drupal.org/node/776230

jmiccolis’s picture

Status: Active » Closed (duplicate)

We're no longer maintaining the 2.x branch, and as no one has volunteered to take it over it's being deprecated. As this has been address in 3.x I'm setting the issue to 'duplicate'.