I'm writing a view that attempts to do the following:

  1. If Content Types A/B
  2. OR If Content Type C and Field 1 Value 1
  3. OR if Content Type D and Field 2 Value 1

Basically, I have 4 content types that I want to filter down to. 2 of those content types are just "ok." Two of those content types are only ok if a particular field has an assigned value, and each type has a different value.

Both fields in this case are boolean fields.

When I build the view, I can have 3 different Content: Type filters (1 for A/B, 2 for C, and 3 for D) and my view will properly return items from all 4 content types. I can split the view into 3 filter groups (Group 1 OR Group 2 OR Group 3) with one content type per group.

As soon as I add a filter for Field 1 = Value 1 and add it to one of the groups, I immediately lose all content from the other two groups. As soon as I add Field 2 = Value 1 to another group, I lose all content from all groups.

It would appear to me that the JOIN statements in the SQL query are causing some sort of problem here. However, after digging, I'm not certain what precisely is the problem. I did originally have contextual filters and relationships on the view, but I simplified it down as far as I could and things are still broken.

Comments

lalweil created an issue. See original summary.

mikemadison’s picture

Title: Filter Gorups Not Functioning As Expected » Filter Groups Not Functioning As Expected
mikemadison’s picture

Issue summary: View changes