Hi,

When I expose the Content AnP: Address - Location filter it works fine when checking locality on only on field example Postal code. But when setting two or more fields on which to check locality (example Thoroughfare & Postal code) I get only empty result.

views query:

SELECT node.nid AS nid,
node.title AS node_title,
gmaps_content_point.vid AS gmaps_content_point_vid,
gmaps_content_point.map_type AS gmaps_content_point_map_type,
gmaps_content_point.latitude AS gmaps_content_point_latitude,
gmaps_content_point.longitude AS gmaps_content_point_longitude,
gmaps_content_point.elevation AS gmaps_content_point_elevation,
gmaps_content_point.x AS gmaps_content_point_x,
gmaps_content_point.y AS gmaps_content_point_y,
gmaps_content_point.z AS gmaps_content_point_z,
gmaps_content_point.privacy AS gmaps_content_point_privacy,
gmaps_content_point.bounds AS gmaps_content_point_bounds,
gmaps_content_point.pov AS gmaps_content_point_pov,
gmaps_content_point.search AS gmaps_content_point_search,
node.vid AS node_vid,
node.uid AS node_uid,
node.type AS node_type
FROM node node
LEFT JOIN gmaps_content_point node_data_field_address_p ON node.vid = node_data_field_address_p.vid AND (node_data_field_address_p.field_name = 'field_address' AND node_data_field_address_p.delta = 0)
LEFT JOIN gmaps_content_address node_data_field_address_a ON node.vid = node_data_field_address_a.vid AND (node_data_field_address_a.field_name = 'field_address' AND node_data_field_address_a.delta = 0)
LEFT JOIN gmaps_content_point gmaps_content_point ON node.vid = gmaps_content_point.vid
WHERE ((node_data_field_address_p.vid IS NULL OR (node_data_field_address_p.vid = node_data_field_address_a.vid AND node_data_field_address_p.field_name = node_data_field_address_a.field_name AND node_data_field_address_p.delta = node_data_field_address_a.delta AND node_data_field_address_p.field_name = 'field_address' AND node_data_field_address_p.delta = 0)))
AND (node_data_field_address_a.country = 'FI')

Comments

xmarket’s picture

Status: Active » Fixed

Please, upgrade to the latest dev (it contains lots of bug fixes related to filters and arguments) and reopen this issue if it still exists.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.