I created a view that has an exposed global combine filter based off the 2 following fields:

  1. node.title
  2. field_data_field_server_known_domains.field_server_known_domains_title

The configuration I've used to create this filter is as follows:

  1. "Expose this filter to visitors," is checked.
  2. "Filter type to expose," has the "single filter" radio selected.
  3. I'm using the "Contains any word," operator and of course, the two fields I mention above.

Beyond that, the view also filters on published content and if it's of a specific content type.

I have gobs of content that meet the criteria of the filtering scheme I've used in this view but for the life of me, I can't understand why the global combine filter isn't working and yes, I've verified that it's this that's causing the problems. When I try to filter on only 1 of the fields using a standard filter, everything works but the reason I need the global combine filter is so that I can have the single filter for multiple fields. So it's kind of a deal breaker.

According to Views UI, the SQL I'm executing when using the global combine filter is as follows:

SELECT node.title AS node_title, node.nid AS nid, 'node' AS field_data_field_server_known_domains_node_entity_type, 'node' AS field_data_field_server_cpus_node_entity_type, 'node' AS field_data_field_server_depends_on_node_entity_type, 'node' AS field_data_field_server_ip_addresses_node_entity_type, 'node' AS field_data_field_server_is_this_a_vm_node_entity_type, 'node' AS field_data_field_server_operating_system_node_entity_type, 'node' AS field_data_field_server_port_matrix_node_entity_type, 'node' AS field_data_field_server_primary_usage_node_entity_type, 'node' AS field_data_field_server_ram_node_entity_type, 'node' AS field_data_field_server_required_by_node_entity_type, 'node' AS field_data_field_storage_space_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_server_known_domains} field_data_field_server_known_domains ON node.nid = field_data_field_server_known_domains.entity_id AND (field_data_field_server_known_domains.entity_type = 'node' AND field_data_field_server_known_domains.deleted = '0')
WHERE ((( (CONVERT(CONCAT_WS(' ', node.title, ' ', field_data_field_server_known_domains.field_server_known_domains_url) USING utf8) LIKE '%foobar%') )AND (node.status = '1') AND (node.type IN  ('server_page')) ))
ORDER BY node_title ASC

It's worth noting 2 issues up to this point:
1.) Views (or *whatever*) is automatically assuming that fields created from the Link Module need to be filtered by their "url" value and not their title field. This would make the Global Combine functionality moot if one is trying to filter based off of the link field's value.

2.) Taking the SQL above and plopping it into MySQL Workbench--and substituting the url with title, it still doesn't work. Nodes are not returned based on the keyword LIKE clause value "foobar" when they exist in the field_server_known_domains_title field.

There are no other configurations worth mentioning with the global combine filter I've created but long story short, I'm essentially trying to look for "foobar" in the node.title and field_data_field_server_known_domains.field_server_known_domains_title fields and it's not finding anything in MySQL Workbench (when it should). For whatever it's worth, the field_data_field_server_known_domains.field_server_known_domains_title field does allow for multiple values... Could this cause issues?

Any ideas about what might be causing this would be appreciated.

Comments

MustangGB’s picture

Status: Active » Closed (outdated)

Closing this as outdated to tidy up a bit around here. If you're still having problems with the latest release please create a new issue.