Filters does not produce good sql
dereine - October 20, 2009 - 18:59
| Project: | Views |
| Version: | 7.x-3.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
Currently the filters does not work because of not correct sql
SELECT node.nid AS nid, node.sticky AS node_sticky, node.created AS node_created FROM {node} node WHERE (( (node.promote <> 0 = :db_condition_placeholder_0) )The current views_handler_filter_boolean_operator does not use value and operator for where(). it would be possible to do it,but
there has to be a way to add custom sql to where.
So i thought if there is no operator and no value added it should be used $query->where instead of $query->condition, here is a patch for it.
This does definitive needs review, i don't know how the where part is planned, what should be supported etc.
| Attachment | Size |
|---|---|
| views-query-filter.patch | 740 bytes |
#1
Updated version
#2
next version
#3
yet another version.
#4
Even better, i hope.
#5
Finally fixed with http://bazaar.launchpad.net/~d7cx/d7cx-views/DRUPAL-7--3/revision/220
#6
Automatically closed -- issue fixed for 2 weeks with no activity.