Hello,
In my view I basically use two content types: research_paper and review. The connection between them is based on a user reference cck-field (it's the reviewer). I need a WHERE clause which results in papers not yet reviewed or paper reviewed by the current user. Therefore I created this filter:
Views Or: Begin alternatives =
(Referer Paper) User: Current Yes
Views Or: Next alternative =
(Referer Paper) User: Name
Views Or: End alternatives = This produces this SQL: ((node_node__users.uid = ***CURRENT_USER***) AND (node_node__users.uid IS NOT NULL)) OR ((node_node__users2.uid IS NULL) AND (node_node__users2.uid IS NOT NULL))
I don't really understand why 'users.uid IS NOT NULL' piece is needed. However, in the first half of the clause it doesn't cause any trouble, but (node_node__users2.uid IS NULL) AND (node_node__users2.uid IS NOT NULL) is totally nonsense.
Is there any way to fix this issue?
Thanks in advance!