I looked up this one before posting: Views filter criteria multiple content types (Drupal 7)
And even though the problem is the same, the solutions provided do not seem to work.
I have Content Types A and B. B has a boolean field.
I need to filter and display all As and Bs if boolean is true.
My filter setup looks like this:
Content : Published AND Content Type : A
Content : Published AND Content Type : B AND Boolean Field : True
The Query that gets produced is the following:
SELECT node.title AS node_title, node.nid AS nid, node.created AS node_created FROM `node` INNER JOIN `field_data_field_boolean` ON node.nid = field_data_field_boolean.entity_id AND (field_data_field_boolean.entity_type = 'node' AND field_data_field_boolean.deleted = '0') WHERE (( (node.status = '1') AND (node.type IN ('poll')) )OR( (node.status = '1') AND (node.type IN ('webform')) AND (field_data_field_boolean.field_boolean_value = '1') )) ORDER BY node_created DESC
The problem is that Inner Join that gets produced instead of a Left Join for instance.
Which setup would allow me to perform the required filtering?
EDIT: Seems it's a know bug. Related links: http://drupal.org/node/1766338 Changing an inner join to a left join in views 3.3?