Download & Extend
Addresses » Issues

Using City or State as Argument in views.

Posted by profundiz on April 3, 2009 at 6:00pm
Project:Addresses
Version:6.x-1.x-dev
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed (duplicate)

Issue Summary

In views I am able to select "City" or a "State" as an argument, but when i look at the mysql query it always looks up the "Address Name".

SELECT node.nid AS nid,
   node.sticky AS node_sticky,
   node.title AS node_title
FROM node node
LEFT JOIN content_type_plumber node_data_field_address ON node.vid = node_data_field_address.vid
WHERE (node.type in ('plumber')) AND (node_data_field_address.field_address_aname = 'montgomery')
   ORDER BY node_sticky ASC, node_title ASC

Am I doing something wrong?

Login or register to post comments

Comments

#1

Posted by codemann on April 10, 2009 at 1:11pm

I'm having the same problem :(

#2

Posted by amsan on October 28, 2009 at 11:44am

I am also experiencing this issue:
When selecting "country" as an argument, the query generated still reads (node_data_field_address.field_address_aname = 'uk').

#3

Posted by codycraven on January 10, 2010 at 4:11am
Assigned to:profundiz» Anonymous
Status:active» closed (duplicate)

You are not doing anything wrong. This is an issue with Addresses. Antoine and I am working to solve this in #324331: CCK addresses fields not displayed in views.