Using City or State as Argument in views.
profundiz - April 3, 2009 - 18:00
| Project: | Addresses |
| Version: | 6.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | profundiz |
| Status: | active |
Jump to:
Description
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 ASCAm I doing something wrong?
#1
I'm having the same problem :(
#2
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').