Hi,

I have a content type with 2 group audience fields, let's call them A and B. I'm trying to build a view that displays content present in one group part of field A AND in another group part of field B, but this isn't working.

The generated SQL query is the following:

SELECT node.title AS node_title, node.nid AS nid FROM node LEFT JOIN og_membership ON node.nid = og_membership.etid AND og_membership.entity_type = 'node' WHERE (node.status = '1' AND node.type = 'hr_document' AND og_membership.gid IN ('1191') AND og_membership.gid = '84') LIMIT 5;

while it should be the following:

SELECT node.title AS node_title, node.nid AS nid FROM node LEFT JOIN og_membership AS og_membership1 ON node.nid = og_membership1.etid AND og_membership1.entity_type = 'node' LEFT JOIN og_membership AS og_membership2 ON node.nid = og_membership2.etid AND og_membership2.entity_type = 'node' WHERE (node.status = '1' AND node.type = 'hr_document' AND og_membership2.gid IN ('1191') AND og_membership1.gid = '84') LIMIT 5;

I'm investigating on how to fix this, but obviously any idea is welcome...