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

dawehner’s picture

Status: Active » Postponed (maintainer needs more info)

Could 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.

esmerel’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)

No update to request for more info in more than 30 days.