Proximity filter adds a 'and (0)' to the view sql even if unset
nehal.padia - September 22, 2009 - 14:48
| Project: | Location Views |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
| Issue tags: | location, Location proximity view, views |
Description
We are using location views and have used a "Location: Distance / Proximity" as one of the filters, see attached 1.jpg. Even though the value is not set of the zipcode, it adds a additional "and (0)" to the view's sql, see below & 2.jpg.
........
........
WHERE (node.type in ('listing_elite', 'listing_portfolio')) AND (node.status <> 0) AND (0)
ORDER BY node_title ASC
Some one please help.
| Attachment | Size |
|---|---|
| Location: Distance / Proximity | 48.87 KB |
| View's SQL | 22.33 KB |
