By maen on

I have a views calendar which shall show results of 2 content types. These 2 content types have different exposed filters, combined by 'or' groups.
Without filters I see the results. With 1 filter, doesn't matter which one, I get the correct result. The 2 filters together I get no result.

Here's my filter group as a picture:
http://i.stack.imgur.com/3enCd.png

And here are the where clauses from sql.:

This is correct: Shows every entry from "veranstaltung" and the filtered result from "terminfrei":

WHERE (
    ( "bla"
    )
AND (
        ( (node.status = '1') AND (node.type IN  ('veranstaltung')) )
    OR
        ( (node.status = '1') AND (node.type IN  ('terminfrei')) AND (taxonomy_index.tid = '49') )
    )
  )
  ORDER BY field_data_field_datum_field_datum_value ASC

Next is also correct, shows every "terminfrei" and filtered result of "veranstaltung":

WHERE (
    ("bla"
    )
AND (
        ( (node.status = '1') AND (node_field_data_field_lokalit_t__taxonomy_index.tid = '49') 
            AND (node.type IN  ('veranstaltung')) 
        )
    OR  ( (node.status = '1') AND (node.type IN  ('terminfrei')) )
    )
  )
  ORDER BY field_data_field_datum_field_datum_value ASC

And here the problem, shows nothing when both exposed filters are filled:

WHERE (
    ("bla" )
AND(
        ( (node.status = '1') AND (node_field_data_field_lokalit_t__taxonomy_index.tid = '49') 
            AND (node.type IN  ('veranstaltung')) 
            )
    OR
        ( (node.status = '1') AND (node.type IN  ('terminfrei')) AND (taxonomy_index.tid = '49') 
      )
    )
  )
  ORDER BY field_data_field_datum_field_datum_value ASC

What I did expect were the filtered results of both content types instead, because of the "or" between the groups. So what do I misunderstand?

THX in advance

maen

⋅ Categories: Drupal 7.x