Closed (won't fix)
Project:
Views (for Drupal 7)
Version:
6.x-2.3
Component:
exposed filters
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
3 Mar 2009 at 15:05 UTC
Updated:
8 Jul 2010 at 20:54 UTC
I have a profile field called "keywords". In the View, users can optionally enter keywords into exposed filter. I have checkmarked "optional" for the filter along with operator "contains" value. First page results are correct and it shows the list of users with nothing in the keywords field...
Now click the Page 2 (of Pager) and the results ONLY show users with something in the keyword field.
Here is the sql for the CORRECT first page:
SELECT users.uid AS uid,
profile_values_profile_name.value AS profile_values_profile_name_value,
users.name AS users_name,
profile_values_profile_city.value AS profile_values_profile_city_value,
profile_values_profile_state.value AS profile_values_profile_state_value,
profile_values_profile_keywords.value AS profile_values_profile_keywords_value,
users.access AS users_access,
users.created AS users_created
FROM users users
LEFT JOIN users_roles users_roles_value_0 ON users.uid = users_roles_value_0.uid AND users_roles_value_0.rid = 3
LEFT JOIN users_roles users_roles_value_1 ON users.uid = users_roles_value_1.uid AND users_roles_value_1.rid = 5
LEFT JOIN users_roles users_roles_value_2 ON users.uid = users_roles_value_2.uid AND users_roles_value_2.rid = 4
LEFT JOIN profile_values profile_values_profile_name ON users.uid = profile_values_profile_name.uid AND profile_values_profile_name.fid = '9'
LEFT JOIN profile_values profile_values_profile_city ON users.uid = profile_values_profile_city.uid AND profile_values_profile_city.fid = '11'
LEFT JOIN profile_values profile_values_profile_state ON users.uid = profile_values_profile_state.uid AND profile_values_profile_state.fid = '12'
LEFT JOIN profile_values profile_values_profile_keywords ON users.uid = profile_values_profile_keywords.uid AND profile_values_profile_keywords.fid = '17'
WHERE (users.status <> 0) AND (users_roles_value_0.rid = 3 OR users_roles_value_1.rid = 5 OR users_roles_value_2.rid = 4)
ORDER BY profile_values_profile_name_value ASC
and the SQL when the second page is clicked the
LAST LINE IS changed to:
WHERE (users.status <> 0) AND (users_roles_value_0.rid = 3 OR users_roles_value_1.rid = 5 OR users_roles_value_2.rid = 4) AND ((profile_values_profile_keywords.value) LIKE ('%%'))
ORDER BY profile_values_profile_name_value ASC
So, the pager is ADDING ...keywords.value Like %%
It should be OMITTED with the exposed filter "optional" checkmarked.
Thanks
- MaineBob
Comments
Comment #1
dawehnerCould you please try to verify whether this is still the case?
If yes, it would be cool if you could provide a views export to make this reproducable.
Therefore try to make a very easy view.
Comment #2
esmerel commentedNo update to request for more info in more than 30 days.