I'm trying to create a view that lists files that were attached to nodes and their comments in an organic groups context. The way I do it works for the admin user, but stops working halfway for anybody else.
Setup: As relations add File: Content using attachments (right now I only have one content type of the kind), then add another relationship to get OG membership from node and link it to the first one. For comments I use the relations Comment using attachments, then Comment: Content to get the node for the comment, then get OG from that node. This works fine in the preview where admin sees it (so far no contextual or other filters set).
None of the relationships are marked as required.
However, it doesn't work for a regular user. I can get the Content set up and it works, or I can get the comments setup and it works. But as soon as there is a second Node in the relations, it stops working. As far as I can rell all relationships are linked correctly. Admin sees everything as it should be, after all.
I'm thinking of a workaround with a view within a view, but does anyone have any idea why the current setup doesn't work?